video query
SELECT
sakila_country_0.country AS sakila_country_0_country,
SUM(CASE
WHEN sakila_film_0.rating = 'G' THEN sakila_payment_0.amount
END) AS sakila_film_0_rating_sakila_payment_0_formula0_0,
SUM(CASE
WHEN sakila_film_0.rating = 'PG' THEN sakila_payment_0.amount
END) AS sakila_film_0_rating_sakila_payment_0_formula0_1,
SUM(CASE
WHEN sakila_film_0.rating = 'PG-13' THEN sakila_payment_0.amount
END) AS sakila_film_0_rating_sakila_payment_0_formula0_2,
SUM(CASE
WHEN sakila_film_0.rating = 'R' THEN sakila_payment_0.amount
END) AS sakila_film_0_rating_sakila_payment_0_formula0_3,
SUM(CASE
WHEN sakila_film_0.rating = 'NC-17' THEN sakila_payment_0.amount
END) AS sakila_film_0_rating_sakila_payment_0_formula0_4,
SUM(sakila_payment_0.amount) AS sakila_payment_0_formula0
FROM
sakila.payment sakila_payment_0
JOIN
sakila.rental sakila_rental_0 ON (sakila_rental_0.rental_id = sakila_payment_0.rental_id
AND sakila_rental_0.staff_id IN (SELECT
sakila_staff_0.staff_id
FROM
sakila.staff sakila_staff_0
WHERE
sakila_staff_0.address_id IN (SELECT
sakila_address_1.address_id
FROM
sakila.address sakila_address_1
WHERE
sakila_address_1.city_id IN (SELECT
sakila_city_1.city_id
FROM
sakila.city sakila_city_1
WHERE
sakila_city_1.country_id IN (SELECT
sakila_country_1.country_id
FROM
sakila.country sakila_country_1
WHERE
sakila_country_1.country = 'Canada')))))
JOIN
sakila.inventory sakila_inventory_0 ON (sakila_inventory_0.inventory_id = sakila_rental_0.inventory_id
AND sakila_inventory_0.store_id IN (SELECT
sakila_store_0.store_id
FROM
sakila.store sakila_store_0
WHERE
sakila_store_0.address_id IN (SELECT
sakila_address_1.address_id
FROM
sakila.address sakila_address_1
WHERE
sakila_address_1.city_id IN (SELECT
sakila_city_1.city_id
FROM
sakila.city sakila_city_1
WHERE
sakila_city_1.country_id IN (SELECT
sakila_country_1.country_id
FROM
sakila.country sakila_country_1
WHERE
sakila_country_1.country = 'Canada')))))
JOIN
sakila.film sakila_film_0 ON (sakila_film_0.film_id = sakila_inventory_0.film_id
AND sakila_film_0.film_id IN (SELECT
sakila_film_actor_0.film_id
FROM
sakila.film_actor sakila_film_actor_0
WHERE
sakila_film_actor_0.actor_id IN (SELECT
sakila_actor_0.actor_id
FROM
sakila.actor sakila_actor_0
WHERE
sakila_actor_0.last_update = '2006-02-15 04:34:33'))
AND (sakila_film_0.language_id IN (SELECT
sakila_language_0.language_id
FROM
sakila.language sakila_language_0
WHERE
sakila_language_0.name = 'English')
OR sakila_film_0.original_language_id IN (SELECT
sakila_language_0.language_id
FROM
sakila.language sakila_language_0
WHERE
sakila_language_0.name = 'English')))
JOIN
sakila.film_category sakila_film_category_0 ON sakila_film_category_0.film_id = sakila_film_0.film_id
JOIN
sakila.category sakila_category_0 ON (sakila_category_0.category_id = sakila_film_category_0.category_id
AND sakila_category_0.name = 'Animation')
JOIN
sakila.customer sakila_customer_0 ON (sakila_customer_0.customer_id = sakila_payment_0.customer_id
AND sakila_customer_0.store_id IN (SELECT
sakila_store_0.store_id
FROM
sakila.store sakila_store_0
WHERE
sakila_store_0.address_id IN (SELECT
sakila_address_1.address_id
FROM
sakila.address sakila_address_1
WHERE
sakila_address_1.city_id IN (SELECT
sakila_city_1.city_id
FROM
sakila.city sakila_city_1
WHERE
sakila_city_1.country_id IN (SELECT
sakila_country_1.country_id
FROM
sakila.country sakila_country_1
WHERE
sakila_country_1.country = 'Canada')))))
JOIN
sakila.address sakila_address_0 ON sakila_address_0.address_id = sakila_customer_0.address_id
JOIN
sakila.city sakila_city_0 ON sakila_city_0.city_id = sakila_address_0.city_id
JOIN
sakila.country sakila_country_0 ON (sakila_country_0.country_id = sakila_city_0.country_id
AND sakila_country_0.country IN ('China' , 'India', 'Japan', 'United States'))
WHERE
sakila_payment_0.staff_id IN (SELECT
sakila_staff_0.staff_id
FROM
sakila.staff sakila_staff_0
WHERE
sakila_staff_0.address_id IN (SELECT
sakila_address_1.address_id
FROM
sakila.address sakila_address_1
WHERE
sakila_address_1.city_id IN (SELECT
sakila_city_1.city_id
FROM
sakila.city sakila_city_1
WHERE
sakila_city_1.country_id IN (SELECT
sakila_country_1.country_id
FROM
sakila.country sakila_country_1
WHERE
sakila_country_1.country = 'Canada'))))
GROUP BY sakila_country_0.country