Menu
CoddyTech

Catalog Shortlist

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

Build a catalog report for products priced below 25 with positive stock. Return id, name and price, ordered by price ascending then id. This is the first project step.

challenge icon

Challenge

Medium

Build a catalog report for products priced below 25 with positive stock. Return id, name and price, ordered by price ascending then id. This is the first project step.

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.
quiz iconTest yourself

This lesson includes a short quiz. Start the lesson to answer it and track your progress.

All lessons in First Queries

Practice on your own: PostgreSQL playground