Flex your T-SQL skills: you’re challenged to write four different (but related) queries in this query writing challenge.
Each query is related
The queries that you are challenged to write are each related to the prior query. The final challenge is the most complex. You can start at the fourth challenge and just do that one, or work through the challenge, copy the prior query, and build upon that — choose your own adventure.