Question 4:
12 854
Phylis Adkins New York NY
Picture 3.1
Write a query to select product_id, product_name, list_price all Product where price between 1500 and 2000 as following:
5 of 5
Paper No: 1
18
2
product id product_name
Trek Remedy 29 Carbon Frameset-2016
list price
1799.99
10
Surly Straggler-2016
1549.00
3 11
Surly Straggler 650b-2016
1680.99
4
31
Surly Wednesday-2017
1632.99
5
57
Trek Emonda S 5-2017
1999.99
6 60
Sun Bicycles BectroLite 2017
1559.99
7 128
Surly ECR 27.5-2018
1899.00
8 136
Trek Procaliber 6-2018
1799.99
9 141
Trek Stache 5-2018
1599.99
10 144
Trek Domane ALR 4 Disc-2018
1549.99
11 145
Trek Domane ALR 5 Disc-2018 Trek Domane ALR 5 Gravel-2018
1799.99
12 147
1799.99
13 151
Trek Domane ALR 4 Disc Women's-2018
1549.99
14 161
Surty ECR-2018
1899.00
15 168
Surly Straggler-2018
1549.00
Picture 4.1
Zoom
Question 5:
Write a query to display customer_id, full_name, number_of_order all customers; display
+ 100%
Close
