Zoom
Question 3:
Results Messages
customer_id first_name last_name city
1
269
Barton Crosby Bellmore NY
state
2
324
Laureen Paul
Bellmore NY
3
410
Conception Slater Bellmore NY
4 431
Luciano
Marsh
Bellmore NY
5
477
Arminda Weber Bellmore NY
6
517
Buford Gilbert Bellmore NY
7
809
Elnora
Simpson
Bellmore NY
8 16
Emmitt Sanchez New York NY
9 178
Genoveva Tyler
New York
10 327
11 411
12 854
Sharie Alvarez New York NY
Octavia Case New York NY
Phylis Adkins New York NY
NY
Picture 3.1
Question 4:
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
product id product_name
list price
18
Trek Remedy 29 Carbon Frameset-2016
1799.99
2
10
Surly Straggler-2016
1549.00
3
11
Surly Straggler 650b-2016 Surly Wednesday-2017
1680.99
4
31
1632.99
+ 100%
Close