https://solvesql.com/problems/revenue-pct-per-category/ https://solvesql.com/problems/revenue-pct-per-category/ solvesql.com [풀이]SELECT category, sub_category,ROUND(SUM(sales),2) AS sales_sub_category,ROUND(SUM(SUM(sales)) OVER (PARTITION BY category), 2) AS sales_category, ROUND(SUM(SUM(sales)) OVER (), 2) AS sales_total, ROUND((SUM(sales) / SUM(SUM(sales)) OVER (PARTITION BY category)) * 100,..