pivot and group query

SELECT 

    YEAR(sakila_rental_0.rental_date) AS sakila_payment_0_formula0,

    MONTH(sakila_rental_0.rental_date) AS sakila_payment_0_formula1,

    SUM(CASE

        WHEN sakila_film_0.rating = 'G' THEN sakila_payment_0.amount

    END) AS sakila_film_0_rating_sakila_payment_0_formula2_0,

    SUM(CASE

        WHEN sakila_film_0.rating = 'PG' THEN sakila_payment_0.amount

    END) AS sakila_film_0_rating_sakila_payment_0_formula2_1,

    SUM(CASE

        WHEN sakila_film_0.rating = 'PG-13' THEN sakila_payment_0.amount

    END) AS sakila_film_0_rating_sakila_payment_0_formula2_2,

    SUM(CASE

        WHEN sakila_film_0.rating = 'R' THEN sakila_payment_0.amount

    END) AS sakila_film_0_rating_sakila_payment_0_formula2_3,

    SUM(CASE

        WHEN sakila_film_0.rating = 'NC-17' THEN sakila_payment_0.amount

    END) AS sakila_film_0_rating_sakila_payment_0_formula2_4,

    SUM(sakila_payment_0.amount) AS sakila_payment_0_formula2

FROM

    sakila.payment sakila_payment_0

        JOIN

    sakila.rental sakila_rental_0 ON sakila_rental_0.rental_id = sakila_payment_0.rental_id

        JOIN

    sakila.inventory sakila_inventory_0 ON sakila_inventory_0.inventory_id = sakila_rental_0.inventory_id

        JOIN

    sakila.film sakila_film_0 ON sakila_film_0.film_id = sakila_inventory_0.film_id

GROUP BY YEAR(sakila_rental_0.rental_date) , MONTH(sakila_rental_0.rental_date);