[SQL문제풀기] 카테고리 별 매출 비율

문제

solvesql.com

https://solvesql.com/problems/revenue-pct-per-category/

SQLite

내가 작성한 정답

with cate as (select category, sum(sales) sales_category
              from records 
              group by category)
select c.category, r.sub_category, 
       round(c.sales_category,2) sales_category,
       round(sum(r.sales),2) sales_sub_category,
       round((select sum(sales) from records),2) sales_total,
       round(sum(r.sales)*100.0/c.sales_category,2) pct_in_category,
       round(sum(r.sales)*100.0/(select sum(sales) from records),2) pct_in_total
from records r
join cate c on r.category = c.category
group by c.category, r.sub_category