Each Order's Share of Customer Spend: Medium SQL Practice Problem

Medium

Description

For customers 1 and 2, show customer_id, order_id, total_amount and pct_of_customer: the order's total_amount as a percentage of that customer's total over all their orders, rounded to 2 decimal places.

End your query with ORDER BY customer_id, order_id.

Tables

orders
order_id (PK)
customer_id (FK)
total_amount

Medium

Description

End your query with ORDER BY customer_id, order_id.

Tables

orders
order_id (PK)
customer_id (FK)
total_amount

customer_id	order_id	total_amount	pct_of_customer
1	1	25798.00	18.40
1	30	10471.15	7.47
1	32	14495.00	10.34
1	48	12746.10	9.09
1	117	7647.30	5.45
1	152	7647.30	5.45
1	168	11996.00	8.56
1	210	14495.00	10.34
1	218	11296.20	8.06
1	228	12621.15	9.00
1	292	10996.00	7.84
2	2	4698.00	2.57
2	39	7972.15	4.36
2	91	13745.30	7.52
2	121	9147.10	5.01
2	123	14445.30	7.91
2	131	13370.45	7.32
2	143	10896.40	5.96
2	193	12621.15	6.91
2	217	15245.10	8.34
2	223	12996.00	7.11
2	238	8322.05	4.56
2	275	10246.30	5.61
2	279	5823.05	3.19
2	282	15294.90	8.37
2	285	13370.45	7.32
2	291	14495.00	7.93

Medium

Description

End your query with ORDER BY customer_id, order_id.

Tables

orders
order_id (PK)
customer_id (FK)
total_amount

Medium

Description

End your query with ORDER BY customer_id, order_id.

Tables

orders
order_id (PK)
customer_id (FK)
total_amount