NumberOfProducts
10
ModelID
ModelName
1
23
Mountain-500
2
19
Mountain-100
8
3
20
Mountain-200
6
4
15
ML Mountain Frame-W
5
5
21
Mountain-300
4
6
22
Mountain-400-W
4
7
14
ML Mountain Frame
3
8
45
ML Mountain Front Wheel
1
9
54
ML Mountain Handlebars
1
10
63
ML Mountain Pedal
1
11
124
ML Mountain Rear Wheel
1
12 80
ML Mountain Seat/Saddle 2 1
13 86
ML Mountain Tire
1
14
112
Mountain Bottle Cage
1
15 117
Mountain Pump
1
16 92
Mountain Tire Tube
1
17 72
ML Mountain Seat/Saddle 10
18 18
Mountain Bike Socks
0
19 39
Mountain-400
0
Picture 5.1
Question 6:
[1 mark] Write a query to display ProductID, Name, Total Quantity of the products having the highest TotalQuantity; where TotalQuantity is the total quantity in all locations of the
Zoom
+ 100%
Close
