SQL_QUERY = """
SELECT rating, COUNT(*) FROM film GROUP BY rating;
"""
pd.read_sql(SQL_QUERY, db)
rating | COUNT(*) | |
---|---|---|
0 | G | 178 |
1 | PG | 194 |
2 | PG-13 | 223 |
3 | R | 195 |
4 | NC-17 | 210 |
SQL_QUERY = """
SELECT rating, COUNT(*) FROM film GROUP BY rating;
"""
pd.read_sql(SQL_QUERY, db)
rating | COUNT(*) | |
---|---|---|
0 | G | 178 |
1 | PG | 194 |
2 | PG-13 | 223 |
3 | R | 195 |
4 | NC-17 | 210 |
SQL_QUERY = """
SELECT COUNT(*), rating, AVG(rental_rate) FROM film GROUP BY rating;
"""
pd.read_sql(SQL_QUERY, db)
COUNT(*) | rating | AVG(rental_rate) | |
---|---|---|---|
0 | 178 | G | 2.888876 |
1 | 194 | PG | 3.051856 |
2 | 223 | PG-13 | 3.034843 |
3 | 195 | R | 2.938718 |
4 | 210 | NC-17 | 2.970952 |
SQL_QUERY = """
SELECT COUNT(*), rating, AVG(rental_rate) FROM film GROUP BY rating ORDER BY AVG(rental_rate) DESC;
"""
pd.read_sql(SQL_QUERY, db)
COUNT(*) | rating | AVG(rental_rate) | |
---|---|---|---|
0 | 194 | PG | 3.051856 |
1 | 223 | PG-13 | 3.034843 |
2 | 210 | NC-17 | 2.970952 |
3 | 195 | R | 2.938718 |
4 | 178 | G | 2.888876 |
SQL_QUERY = """
SELECT
COUNT(*) AS total_films,
rating,
AVG(rental_rate) AS avg_rental_rate
FROM film
GROUP BY rating
ORDER BY avg_rental_rate DESC;
"""
pd.read_sql(SQL_QUERY, db)
total_films | rating | avg_rental_rate | |
---|---|---|---|
0 | 194 | PG | 3.051856 |
1 | 223 | PG-13 | 3.034843 |
2 | 210 | NC-17 | 2.970952 |
3 | 195 | R | 2.938718 |
4 | 178 | G | 2.888876 |
SQL_QUERY = """
SELECT
rating,
COUNT(*) "total_films",
AVG(rental_rate) "average_rental_rate"
FROM film
GROUP BY 1
ORDER BY 3
;
"""
SQL_QUERY = """
SELECT
rating,
COUNT(*) total_films,
AVG(rental_rate) average_rental_rate
FROM film
GROUP BY 1
ORDER BY 3
;
"""
pd.read_sql(SQL_QUERY, db)
rating | total_films | average_rental_rate | |
---|---|---|---|
0 | G | 178 | 2.888876 |
1 | R | 195 | 2.938718 |
2 | NC-17 | 210 | 2.970952 |
3 | PG-13 | 223 | 3.034843 |
4 | PG | 194 | 3.051856 |