Project 28: Top Pages Report
SQL Architect
Query Task
Objective
Review day: a complete multi-clause SELECT — WHERE, GROUP BY, HAVING, ORDER BY, and LIMIT all in one query, the full shape a real reporting query usually takes.
You're given a page_views table with columns id, page, viewed_at, and is_admin.
Task: return page and a count of views (as views), for non-admin views only, grouped by page, keeping only pages with more than 10 views, sorted by views descending, limited to 5 rows.
query.sql
SELECT page, COUNT(*) AS views FROM page_views WHERE is_admin = false GROUP BY page HAVING COUNT(*) > 10 ORDER BY views DESC LIMIT 5;
* Hint: Correct characters turn green, incorrect ones turn red.
Query Results
🗄️
Execute your query to see results