Challenge: Use Joins to Combine Rows
Test your knowledge of joins with this challenge.
We'll cover the following...
Problem statement
- How many students are enrolled in each course?
- There are five students, but only four are currently registered in any courses. Write a query to show this information.
The students
sample table is below:
+----+--------+---------------------+----------------------+
| id | name | address | date_of_registration |
+----+--------+---------------------+----------------------+
| 1 | John |
...