These are chat archives for MarcosSegovia/MPWAR1516

2nd
Feb 2016
Pablo Puga
@pablo-puga
Feb 02 2016 20:21
SELECT
category.name AS category_name,
sum(payment.amount) AS sells_amount
FROM payment
INNER JOIN rental USING (rental_id)
INNER JOIN inventory USING (inventory_id)
INNER JOIN film_category USING (film_id)
INNER JOIN category USING (category_id)
GROUP BY category.name;