Here, you can find all of my SQL projects (continually updated with new and/or tuned projects)
Fiftyville provided 2 clues about a theft that took place: time and place. My task was to create queries based on the information provided, investigate those results, and create queries based on the results to find who the thief was, what city they escaped to, and who their accomplice was.
Using a database from IMDb, Movies tasked me with creating various queries for movie information. movies.db provides data about movies, stars, directors, and the ratings. I implemented 13 different queries with implementation details are located at the top of each SQL file.
songs.db is a database that stores data from Spotify about the music on their platform. It contains the top 100 streamed songs from 2018. This project required that I implement 8 different queries for various data which includes overlapping tables. The implementation details are located at the top of each SQL file.