rental_df = pd.read_sql("SELECT * FROM rental;", db)
rental_df.head()
inventory_df = pd.read_sql("SELECT * FROM inventory;", db)
inventory_df.head()
inventory_df_groupby = pd.read_sql("SELECT film_id, COUNT(*) FROM inventory GROUP BY film_id", db)
inventory_df_groupby.head()
film_df = pd.read_sql("SELECT * FROM film;", db)
film_df.head()
film_category_df = pd.read_sql("SELECT * FROM film_category;", db)
film_category_df.head()
category_df = pd.read_sql("SELECT * FROM category;", db)
category_df.head()
SQL_QUERY = """
SELECT inventory.film_id, rental.rental_id
FROM rental
JOIN inventory
ON inventory.inventory_id = rental.inventory_id
"""
category_rental_df = pd.read_sql(SQL_QUERY, db)
category_rental_df.head()
SQL_QUERY = """
SELECT category.name, inventory.film_id, rental.rental_id
FROM rental
JOIN inventory ON inventory.inventory_id = rental.inventory_id
JOIN film_category ON film_category.film_id = inventory.film_id
JOIN category ON category.category_id = film_category.category_id
WHERE category.name = 'Comedy'
"""
category_rental_df = pd.read_sql(SQL_QUERY, db)
category_rental_df.head()
SQL_QUERY = """
"""
category_rental_df = pd.read_sql(SQL_QUERY, db)
category_rental_df.head()
SQL_QUERY = """
SELECT COUNT(*)
FROM rental
JOIN inventory ON inventory.inventory_id = rental.inventory_id
JOIN film_category ON film_category.film_id = inventory.film_id
JOIN category ON category.category_id = film_category.category_id
WHERE category.name = 'Comedy'
"""
category_rental_df = pd.read_sql(SQL_QUERY, db)
category_rental_df.head()