K
Kizspy.me
Zoom
purchased greater than or equal to 10 in the year 2020
Question 7:
employee_name
Eminem
order_id total
1
10
Picture 6.1
[1 mark] Write a query to retrieve information about products that have a price lower than
the average selling price of that product.
product_id
1
product_name
Mouse
product_price
20
Picture 7.1
Question 8:
[0.5 mark] Write a query to increase the price in the product table by 10% if the current price
is lower than the selling price (increase only once even if the product has been sold multiple
times).
Question 9:
+ 100%
Close
