EasySQL challenge #93ORDER BY

Latest Reviews

Sort reviews by reviewed_at descending.

The challenge runs on the SQLabHub practice database (SQLite) and uses the reviews table. You can solve it in the browser, with nothing to install.

The task

Sort reviews by reviewed_at descending.

A correct answer returns 180 rows with 7 columns: id, product_id, user_id, rating, comment, reviewed_at, helpful_votes.

id INTEGER (PK) · product_id INTEGER · user_id INTEGER · rating INTEGER · comment TEXT · reviewed_at TEXT · helpful_votes INTEGER

First 3 rows of the reviews table
id	product_id	user_id	rating	comment	reviewed_at	helpful_votes
1	23	45	5	Works perfectly. Very happy with this purchase.	2022-09-02	40
2	101	68	5	Excellent build quality. Will buy again!	2023-01-05	96
3	40	39	1	Would give 6 stars if I could!	2023-05-15	17

The first rows of each table are shown. See how all the tables relate on the database schema page.

Expected output of the challenge
id	product_id	user_id	rating	comment	reviewed_at	helpful_votes
99	32	102	4	Decent but the packaging could be better.	2024-12-11	92
150	8	146	4	Decent but the packaging could be better.	2024-12-10	90
20	17	13	3	Impressive quality. Definitely buying more.	2024-12-01	2
54	42	107	2	Impressive quality. Definitely buying more.	2024-11-27	36
152	58	82	2	Great product, exactly as described. Fast shipping!	2024-11-24	94

First 5 of 180 rows. This is the output of the model solution on the practice database.

Try the challenge first. Open these only when you need them.

Show the hint

ORDER BY DESC

Show the step-by-step approach

How the model solution is built, in the order the database evaluates it:

Checking your session…

ORDER BY. Without ORDER BY the row order is not guaranteed, even if it looks stable. Rows that tie on the sort columns can come back in any order.
SELECT *. SELECT * is fine for exploring, but its output changes whenever a column is added to the table. Queries that feed a report should name their columns.