Learn SQL/

...

/

Solution: Build a Mini Dashboard

Solution: Build a Mini Dashboard

We'll cover the following...

Query

SELECT s.name, COUNT(*) AS high_score_count
FROM students s
JOIN grades g ON s.id = g.student_id
WHERE g.score > 90
GROUP BY s.name
HAVING COUNT(*) > 0
ORDER BY high_score_count DESC;

Explanation

This query counts how many high scores (above 90) each student has and lists them in order of who has the most.

Let’s break it ...