Each Order's Products in One Line

Easy

Description

For each order of customer 7, show:

order_id
units: the total quantity of its lines
products: the names of its products in one text, separated by a comma and a space (, ), from the highest unit_price to the lowest; equal prices go in order of product name

End your query with ORDER BY order_id.

products
product_id (PK)
product_name

Easy

For each order of customer 7, show:

order_id
units: the total quantity of its lines
products: the names of its products in one text, separated by a comma and a space (, ), from the highest unit_price to the lowest; equal prices go in order of product name

End your query with ORDER BY order_id.

products
product_id (PK)
product_name

order_id	units	products
3	2	VoltBook Air 14 Laptop, USB-C Fast Charger 65W
24	4	Building Blocks 250pc, Matte Lipstick Set (6)
37	2	Matte Lipstick Set (6), Whey Protein 1kg
57	4	PixelTab 11 Tablet, The Alchemist
72	5	Steel Pressure Cooker 5L, Cold-Pressed Oil 1L
87	1	Air Fryer 4.5L
100	3	Assorted Dry Fruits 1kg, Strategy Board Game
111	2	Matte Lipstick Set (6), Midnight Mystery Novel
120	4	VoltBook Air 14 Laptop, Nova X5 Smartphone
161	5	Ceramic Dinner Set (18pc), Denim Jacket
183	2	Matte Lipstick Set (6), BassBoom Headphones
225	4	RC Stunt Car, BassBoom Headphones
236	4	Strategy Board Game, Cotton Kurta - Navy
243	2	Cold-Pressed Oil 1L
273	4	Nova X5 Smartphone, Cricket Bat - Kashmir

Easy

For each order of customer 7, show:

order_id
units: the total quantity of its lines
products: the names of its products in one text, separated by a comma and a space (, ), from the highest unit_price to the lowest; equal prices go in order of product name

End your query with ORDER BY order_id.

products
product_id (PK)
product_name

Easy

For each order of customer 7, show:

order_id
units: the total quantity of its lines
products: the names of its products in one text, separated by a comma and a space (, ), from the highest unit_price to the lowest; equal prices go in order of product name

End your query with ORDER BY order_id.

products
product_id (PK)
product_name