promptdojo_

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

Checkpoint

One last thing before we move on. Same surface as a write step — but the lesson doesn't complete until this passes.

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.