Comparing Grades

Another interesting question one of my students has sent me recently. This question tests your understanding of SQL SELF JOIN. Given the following Class Grades table:



Create a query to display all students who received a grade of 100 in Math and Physics.

UpScale Analytics is one of the largest platforms in the world for learning SQL by doing, consisting over 300 SQL exercises at different levels (including solutions), by topics, across over 100 different datasets. More…