A SQL practice exercise with both one, two and three tables.
How to use SQL with more than one table is explained in the exercise.
I suggest that you cover over the SQL statement with a piece of paper (on the left) and then read the explanation only (on the right). Then attempt to write the SQL statement yourself and mark your own work. You need to get 100%, so do it over and over again until you have mastered it. This takes practice and study. Good luck.
Use in conjunction with “SQL Summary Version 5”