Given the table
sales_data with columns
product and
amount, what is the output of this query?
SELECT product, amount, ROUND((amount / SUM(amount) OVER ()) * 100, 1) AS percent_total FROM sales_data ORDER BY product;
Assume the data:
product | amount
-------|-------
A | 50
B | 30
C | 20A[{"product": "A", "amount": 50, "percent_total": 100.0}, {"product": "B", "amount": 30, "percent_total": 100.0}, {"product": "C", "amount": 20, "percent_total": 100.0}]
B[{"product": "A", "amount": 50, "percent_total": 33.3}, {"product": "B", "amount": 30, "percent_total": 20.0}, {"product": "C", "amount": 20, "percent_total": 13.3}]
C[{"product": "A", "amount": 50, "percent_total": 25.0}, {"product": "B", "amount": 30, "percent_total": 15.0}, {"product": "C", "amount": 20, "percent_total": 10.0}]
D[{"product": "A", "amount": 50, "percent_total": 50.0}, {"product": "B", "amount": 30, "percent_total": 30.0}, {"product": "C", "amount": 20, "percent_total": 20.0}]
