CS50x Week 7 introduces SQL through three very different databases — Spotify's top 100 songs, an IMDb movie database with thirteen progressively complex queries, and the Fiftyville mystery where SQL alone is used to solve a crime. Each problem builds on the last, and by the end of the week writing multi-table joins and nested subqueries starts to feel completely natural. Here is how all three came together.