Catalog Snapshot
Part of the First Queries section of Coddy's PostgreSQL journey. Lesson 5 of 20.
Challenge
MediumReturn id, category and price for the four cheapest products. Order by price ascending, 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