SQL Foundations · 20 min · 180 XP
Checkpoint: March packing list
Build a packing list from four tables, with flags a warehouse can act on.
This checkpoint starts from an empty editor. Before you write anything, decide what one row of the answer is, which tables it needs, and which rows must be left out. Open the hint only after your first run.
Everything here comes from the lessons in this module: filtering with WHERE, labelling with CASE, filling gaps with COALESCE, joining, and asking about other rows with EXISTS. The new part is deciding for yourself which piece goes where. A good order of work: get the rows right first, joins and filters, and check the count. Add the columns second.
Loading your workspace…