Chapter 9 · Lesson 3 of 5

03. Project: each subject's topper

Find who got the highest mark in each subject: a join, MAX, and a subquery that looks at one subject at a time.