promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_

Select, filter, aggregate: the feature query shape — step 7 of 7

ch 36 · sql for ml datasetsch 36 · sql for ml datasetsch 36 · sql for ml datasetsch 36 · sql for ml datasetsch 36 · sql for ml datasetsch 36 · sql for ml datasetsch 36 · sql for ml datasetsch 36 · sql for ml datasetsch 36 · sql for ml datasetsch 36 · sql for ml datasetsch 36 · sql for ml datasets7/7
Checkpoint

One last thing before we move on. pass this to mark the lesson done, or skip and keep moving. hop to the next when you're ready.

Checkpoint. Write big_spenders(db, region, floor): users in the given region whose total exceeds floor, as (user, total) sorted by total descending — the full WHERE→GROUP BY→HAVING→ORDER BY shape with parameters (use ? placeholders, never f-strings).

full-screen editor opens — close anytime to keep reading.

open the editor to run it.