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.
Scripts
Grab the scripts for this course: https://github.com/LitKnd/SQLWorkbooks/tree/main/query_writing_most_unique_names
Lessons
Challenge setup and problem (10 minutes) |
Sample solution for the Unique Names SQLChallenge (13 minutes) |