Project 21: Track Play Count Stats
SQL Architect
Builds on these lessons
Query Task
Objective
Aggregate functions — COUNT, SUM, AVG, MIN, MAX — collapse many rows into one number. Used without GROUP BY, they summarize the whole table at once.
You're given a tracks table with columns id, title, and play_count.
Task: write a query returning the average and the maximum play_count across the whole table.
query.sql
SELECT AVG(play_count), MAX(play_count) FROM tracks;
* Hint: Correct characters turn green, incorrect ones turn red.
Query Results
🗄️
Execute your query to see results