Practice · Logistics · Medium
Among projects that are Operational AND have a known capacity, return each project and its capacity_teu_per_yr, largest first.
Runs in your browser. No signup needed.
logistics(project, status, capacity_teu_per_yr). capacity is NULL for ports not measured in TEU — exclude NULLs with IS NOT NULL and filter status = ‘Operational’.
SELECT project, capacity_teu_per_yr
FROM logistics
WHERE status = 'Operational'
AND capacity_teu_per_yr IS NOT NULL
ORDER BY ...;The reference solution is checked automatically when you run your query on the practice page — results are compared row by row, and order matters for this one.
Egypt is building an inland-port and terminal network — from the 6th of October dry port to Damietta’s new DACT terminal — to turn its Suez geography into a logistics industry. (EBRD, Hapag-Lloyd, 2026)