Lowest Review Rating
Find the lowest rating given in reviews.
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
Find the lowest rating given in reviews.
A correct answer returns 1 row with one column: MIN(rating).
Tables used in this challenge
reviews 180 rows
id INTEGER (PK) · product_id INTEGER · user_id INTEGER · rating INTEGER · comment TEXT · reviewed_at TEXT · helpful_votes INTEGER
| id | product_id | user_id | rating | comment | reviewed_at | helpful_votes |
|---|---|---|---|---|---|---|
The first rows of each table are shown. See how all the tables relate on the database schema page.
Expected output
| MIN(rating) |
|---|
The complete result: 1 row. This is the output of the model solution on the practice database.
What you practise
- Summarising many rows into one value with COUNT, SUM, AVG, MIN or MAX
Hint and approach
Try the challenge first. Open these only when you need them.
Show the hint
Use MIN
Show the step-by-step approach
How the model solution is built, in the order the database evaluates it:
- Read from the
reviewstable. - Aggregate over all the rows that are left: compute
MIN(rating). With no GROUP BY, the result is a single row.
Model solution
Checking your session…
What to watch for
- Aggregate functions. Aggregates skip NULLs. AVG divides by the number of non-NULL values and COUNT(column) can be smaller than COUNT(*).
Related SQL challenges
- Find the Lowest Price with MIN()Similar levelEasy
- Count the Rows in a Table with COUNT(*)Similar levelEasy
- Rank Products by Their Average Review RatingHarderHard
- Find the Highest Price with MAX()Similar levelEasy
- Calculate the Average Price with AVG()Similar levelEasy
Keep learning
- Lesson: Aggregate Functions
- All SQL practice challenges, by difficulty and topic
- SQL interview questions with answers
- SQL Playground: run any query on the same database