Project: Build a Mini Dashboard

Task

Write a query that:

• Joins the students and grades tables.

• Filters to include only scores greater than 90.

• Groups results by student.

• Counts how many high scores (above 90) each student has.

• Only includes students who scored above 90 in at least one subject.

• Displays the student’s name and number of high scores.

• Orders the results by high score count descending.

The students table