We will be analyzing data from a large sample data set. Download and import the SQL dumps for the database schema and the data insertion.
For the following exercises, we will be using the film_list
table. In the SQL file included in this repo, write your responses to the following exercises:
- Write a query that returns the total number of films in our table.
- Write a query that returns the title and descriptions of the ten films with the longest descriptions.
- Write a query that returns the shortest movie, by length.
- Write a query that returns title and description of all of the films that feature
"CAMERON STREEP"
. - Write a query that returns all of the film
genre
s along with their average price and average length. - Write a query that returns all of the film
ratings
s along with a count of how many time that rating appears in our table. - Instead of us calling films "foreign," write a query that updates all "foreign" films to "international" films.
- We don't like "childrens" films. Delete all of them from this table.