Find Dispatch Candidates
Part of the First Queries section of Coddy's PostgreSQL journey. Lesson 10 of 20.
Challenge
MediumReturn id and name for home or travel products with stock at least 5 and a missing note. Order by id.
The input tables are shown in the test panel. Each run starts from fresh data. Return the named columns in the stated order; do not hard-code the displayed rows.
Try it yourself
-- Write your SQL here.
All lessons in First Queries
2Filter the Catalog
Filter with WHERECombine ConditionsMissing Values with NULLSearch Text with ILIKEFind Dispatch CandidatesPractice on your own: PostgreSQL playground