Learn ORDER BY and LIMIT: THE SAFEHOUSE

THE SAFEHOUSE is chapter 3, where result order starts to matter. The BLACKSITES table lists each facility's SITE_CODE, REGION, CAPACITY, and DETAINEES. You sort facilities with ORDER BY and DESC, then cut the report down to the most overcrowded sites with LIMIT.

The chapter's second mission opens the ASSETS ledger, the agency's classified list of paid informants. Budget reauthorization means range filters: ANNUAL_PAYMENT checked with BETWEEN, priority countries matched with IN, and unreliable sources removed with NOT IN.

Together the two missions cover the sorting and filtering tools you will use in almost every real query.

This is the shape of query you practice here, not the answer to any mission. The real stages come with their own data, objectives, and hints.

SELECT SITE_CODE, DETAINEES
FROM BLACKSITES
ORDER BY DETAINEES DESC
LIMIT 5;