Problem: Build a Mini Dashboard
Write a query that:
Joins the
studentsandgradestables.Filters to include only scores greater than 90.
Groups results by student.
Counts how many high scores (above 90) each student has.
Displays the student’s name and number of high scores.
Orders the results by high score count descending.
The students table
ID | Name |
1 | Ali |
2 | Fatima |
3 | Omar |
The grades table
ID | Student ID | Subject | Score |
1 | 1 | Math | 87.5 |
2 | 1 | History | 80.0 |
3 | 2 | Math | 91.0 |
Problem: Build a Mini Dashboard
Write a query that:
Joins the
studentsandgradestables.Filters to include only scores greater than 90.
Groups results by student.
Counts how many high scores (above 90) each student has.
Displays the student’s name and number of high scores.
Orders the results by high score count descending.
The students table
ID | Name |
1 | Ali |
2 | Fatima |
3 | Omar |
The grades table
ID | Student ID | Subject | Score |
1 | 1 | Math | 87.5 |
2 | 1 | History | 80.0 |
3 | 2 | Math | 91.0 |