[mySQL] solvesql 바겐 세일!

Q. https://solvesql.com/problems/bargain-sale/

SELECT order_date,
       SUM(CASE WHEN discount >= 0.8 THEN quantity ELSE 0 END) AS 'big_discount_items',
       SUM(quantity) AS 'all_items'
FROM records 
GROUP BY order_date
HAVING all_items >= 10
AND big_discount_items >= 1
ORDER BY big_discount_items DESC