In the files I've placed here, are some SQL queries based on a data set from a fictional video rental company named Rockbuster.
Simple_Cleaning contains a couple of queries I would use to check the data for missing or duplicate entires.
TopTenSpenders is a demonstration of a slightly more complex query that ends up finding the top ten customers in terms of spending. This particular query also returns not just the customers name, but also the city and country they reside in. Information used later in the following project
The queries I used to create that report are all in the attatched excel file, I encourage you to take a peek. RockbusterReport.xlsx
The Data Dictionary might also be worth a gander if you're the curious about the layout of the database. It's a pdf, for what it's worth. Data Dictionary