SQL Challenge: Monster Sightings
Use QUALIFY, comparison joins, and window functions to solve this data mystery!
Let’s put your SQL skills to the test in this fun SQL challenge!
Whether you are studying for technical interviews, learning SQL for the first time, or looking to improve your use of advanced functions, you’ll not only learn and grow through this challenge, but you’ll have fun.
Let’s get in the Halloween spirit!
Before taking on this challenge, if you wish to brush up on your SQL skills, I recommend reading the following resources:
🎃 Halloween SQL Challenge: The Haunted Mansion Mystery
Welcome to the Annual Monster Masquerade Ball at the Haunted Mansion! Throughout the night, various supernatural creatures have been spotted in different rooms, collecting candy and causing mischief. Your job as the mansion’s data analyst is to solve several spooky mysteries using your SQL skills!
Download the data
You can find the CSV files you need for this challenge here.
🕷️ Challenge Questions
Level 1: The First Sighting Mystery 👁️
Concept: QUALIFY with ROW_NUMBER()
Keep reading with a 7-day free trial
Subscribe to Learn Analytics Engineering to keep reading this post and get 7 days of free access to the full post archives.