Question 3:
[1 mark]. Write a query to list products with a product_name containing the word 'City'. the
result includes: product_id, product_name, and list_price columns, and sort in ascending
order by product_name.as follows.
product_id product_name list_price
1
6
City Lite
259.00
2
7
City Pro
399.00
3
11
E-City 250
1299.00
Picture 3.1
Question 4:
[1 mark]. Write a query to find orders between 2025-08-05 and 2025-08-15 (YYYY-MM-DD).
Display the results including the columns order_id, customer_id, order_date, store_id,
staff_id, and sort in ascending order by the order_date column as follows.
5 of 5
Paper No: 1
Zoom
+ 100%
order_id
customer id
order date
store_id
staff_id
1
5
5
2025-08-05
5
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
Close
