project1_quetion2.sql

/*
  Who are the top 5 active customers who have spent most in renting films?
*/

SELECT DISTINCT customer.customer_id, CONCAT(first_name, ' ', last_name) AS customer,
       SUM(payment.amount) OVER(PARTITION BY customer) AS total_amt_spent
FROM customer
JOIN payment
ON customer.customer_id = payment.customer_id
WHERE customer.active = 1
ORDER BY total_amt_spent DESC
LIMIT 5;