Search⌘ K
AI Features
Home
Courses
Learn SQL

Solution: Build a Mini Dashboard

Explore how to build a mini dashboard by combining data from multiple tables using SQL joins. Learn to filter high scores, count occurrences per student, group results, and sort to identify top performers.

We'll cover the following...
...
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;
...