5 of 5
Paper No: 1
order_id
customer_id
order date
1
5
5
2025-08-05
store_id
5
staff_id
5
2
6
6
2025-08-06 6
6
3
7
7
2025-08-07 7
7
4
8
8
2025-08-08 8
8
5
9
9
2025-08-09 9
9
6
10
10
2025-08-10 10
10
7
11
11
2025-08-11 11
11
8
12
12
2025-08-12 12
12
9
13
13
2025-08-13 13
13
10
14
14
2025-08-14 14
14
11
15
15
2025-08-15 15
15
Picture 4.1
Question 5:
[1 mark] Write a query to find the products with the lowest list_price. Display the results with
the columns product_id, product_name, and list_price as follows.
1
2
product_id
10
13
product_name
Kids Fun 14
BMX Spark
list price
149.00
149.00
Picture 5.1
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.
Zoom
+ 100%
total_qty_in_stock
store_id
store_name
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
Close
