Label expensive products
Return name and a label: Premium when price is at least 80, otherwise Standard. Order by id.
Try it yourself
Open a fresh temporary sample shop dataset. Write your query and use Check answer. Checking uses a separate, clean sample so edits to your workspace cannot change the expected answer. Matches are based on this dataset, not a proof for every possible database.
Open exercise →Sample schema
customers(id, name, email, country, joined_at) products(id, name, category, price) orders(id, customer_id, ordered_at, status, total) order_items(id, order_id, product_id, quantity, unit_price)
About this dataset · Learning paths · SQL reference
Show a hint
Use CASE WHEN ... THEN ... ELSE ... END.
Show one solution
SELECT name, CASE WHEN price >= 80 THEN 'Premium' ELSE 'Standard' END FROM products ORDER BY id;Other queries can produce the same answer. Column aliases are ignored; column order and row order are checked.