A Query Writing SQLChallenge: The Most Unique Names (23 minutes)

Flex your T-SQL skills: you’re challenged to write four different (but related) queries in this query writing challenge.

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)