K
Kizspy.me
Zoom
Question 3:
Find product_id, product_name, model_year and list_price of all products having model_year
is 2018 and list_price is 229.99
1
product_id
274
product_name
2
275
Trek Precaliber 20 Boy's - 2018
Trek Precaliber 20 Girl's - 2018
model year list_price
2018
2018
229.99
229.99
Picture 3.1
Question 4:
Write a query to display product_name, category_name and list_price of all products having
the category_name is Mountain Bikes and list_price smaller than 469.99
+125%
product_name
category_name list_price
1
Trek 820-2016
Mountain Bikes
379.99
2
Haro Flightline One ST-2017 Mountain Bikes
379.99
3
Trek 820-2018
Mountain Bikes
379.99
Dicture 1 1
Close
