Question 6:
[1 mark]. Write a query to calculate the total quantity in each store. Tthe result includes
columns such as store_id, store_name, and total_qty_in_stock, then sort in descending
order by the total_qty_in_stock column and ascending order by the store_id column as
follows.
Question 7:
6 of 6
Paper No: 1
store_id
store_name
total_qty in stock
1
1
Downtown Cycles
17
2
2
Riverside Wheels
16
3
4
Desert Trail
13
4
7
Seaside Spokes
13
5
3
Bay City Bikes
11
6
6
Music City Pedals
11
7
5
Capitol Ride
9
Picture 6.1
[1 mark]. Write a query to find the highest list_price of products within each category_name.
The result includes columns: category_name, product_id, product_name, and list_price, then
sort in ascending order by category_name and product_id as follows.
Zoom
+ 100%
category_name product_id
product_name list price
BMX
13
BMX Spark
149.00
City
7
City Pro
399.00
3
E-Bike
12
E-Mountain 500
2199.00
Fixie
15
Foxie Basic
219.00
5
Folding
9
Folding Go
379.00
6
Gravel
8
Gravel GX
999.00
7
Hybrid
17
Hybrid H3
649.00
8
Kids
10
Kids Fun 14
149.00
9
Mountain
5
Mountain X2
799.00
10
Road
3
Roadster 300
699.00
11
Touring
14
Touring T1
899.00
Close
