Problem: Meet the JOIN Family
Run a LEFT JOIN to find out which students do not have any recorded grades.
Example tables
The students table
ID | Name |
1 | Ali |
2 | Fatima |
3 | Omar |
The grades table
Student ID | Subject | Score |
1 | Math | 87.5 |
1 | History | 80.0 |
2 | Math | 91.0 |
Problem: Meet the JOIN Family
Run a LEFT JOIN to find out which students do not have any recorded grades.
Example tables
The students table
ID | Name |
1 | Ali |
2 | Fatima |
3 | Omar |
The grades table
Student ID | Subject | Score |
1 | Math | 87.5 |
1 | History | 80.0 |
2 | Math | 91.0 |