Answers and explanations · Select only the evidence you need

Exercise 02a

Bag and Guide are the most expensive catalogue products. Sorting by product_id after price makes any future ties deterministic.

SELECT product_id,product_name,list_price FROM aabha_sql.products ORDER BY list_price DESC,product_id LIMIT 2;

Expected output:

Runnable answer: sql/solutions/02a.sql

Exercise 02b

The result contains app and web once each. DISTINCT applies to the one selected column.

SELECT DISTINCT channel FROM aabha_sql.orders ORDER BY channel;

Expected output:

Runnable answer: sql/solutions/02b.sql