Menu
CoddyTech

Travel Packing List

Part of the First Queries section of Coddy's PostgreSQL journey. Lesson 19 of 20.

challenge icon

Challenge

Medium

Return id, name and packing_note for travel products with positive stock. packing_note uses note when present or Travel wrap when missing. Order by stock descending, then 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

Practice on your own: PostgreSQL playground