 Order Details |
|||||
Order ID
|
Product
|
Unit Price
|
Quantity
|
Discount
|
|
10248
|
Queso Cabrales
|
14
|
12
|
2%
|
|
10248
|
Singaporean Hokkien Fried Mee
|
9.8
|
10
|
2%
|
|
10248
|
Mozzarella di Giovanni
|
34.8
|
5
|
4.2%
|
|
10249
|
Tofu
|
18.6
|
9
|
3.1%
|
|
10249
|
Manjimup Dried Apples
|
42.4
|
40
|
2.3%
|
|
10250
|
Jack's New England Clam Chowder
|
7.7
|
10
|
1.2%
|
|
10250
|
Manjimup Dried Apples
|
42.4
|
35
|
0.15%
|
|
10250
|
Louisiana Fiery Hot Pepper Sauce
|
16.8
|
15
|
0.15%
|
|
10251
|
Gustaf's Knäckebröd
|
16.8
|
6
|
0.05%
|
|
10251
|
Ravioli Angelo
|
15.6
|
15
|
0.05%
|
|
10251
|
Louisiana Fiery Hot Pepper Sauce
|
16.8
|
20
|
6%
|
|
10252
|
Sir Rodney's Marmalade
|
64.8
|
40
|
0.05%
|
|
10252
|
Geitost
|
2
|
25
|
0.05
|
|
10252
|
Camembert Pierrot
|
27.2
|
40
|
7%
|
|
10253
|
Gorgonzola Telino
|
10
|
20
|
02.5%
|
|
10253
|
Chartreuse verte
|
14.4
|
42
|
3%
|
|
10253
|
Maxilaku
|
16
|
40
|
1.5%
|
|
10254
|
Guaraná Fantástica
|
3.6
|
15
|
0.15%
|
|
10254
|
Pâté chinois
|
19.2
|
21
|
0.13%
|
|
10254
|
Longlife Tofu
|
8
|
21
|
7%
|
|
10255
|
Chang
|
15.2
|
20
|
3%
|
|
10255
|
Pavlova
|
13.9
|
35
|
6%
|
|
10255
|
Inlagd Sill
|
15.2
|
25
|
3%
|
|
10255
|
Raclette Courdavault
|
44
|
30
|
3%
|
|
10256
|
Perth Pasties
|
26.2
|
15
|
2%
|
|
10256
|
Original Frankfurter grüne Soße
|
10.4
|
12
|
2.5%
|
|
10257
|
Schoggi Schokolade
|
35.1
|
25
|
5%
|
|
10257
|
Chartreuse verte
|
14.4
|
6
|
6%
|
|
10257
|
Original Frankfurter grüne Soße
|
10.4
|
15
|
9%
|
|
10258
|
Chang
|
15.2
|
50
|
0.2%
|
|
10258
|
Chef Anton's Gumbo Mix
|
17
|
65
|
0.2%
|
|
10258
|
Mascarpone Fabioli
|
25.6
|
6
|
0.2%
|
|
10259
|
Sir Rodney's Scones
|
8
|
10
|
1%
|
|
10259
|
Gravad lax
|
20.8
|
1
|
7%
|
|
10260
|
Jack's New England Clam Chowder
|
7.7
|
16
|
0.25%
|
|
10260
|
Ravioli Angelo
|
15.6
|
50
|
3.1%
|
|
10260
|
Tarte au sucre
|
39.4
|
15
|
0.25%
|
|
10260
|
Outback Lager
|
12
|
21
|
0.25%
|
|
10261
|
Sir Rodney's Scones
|
8
|
20
|
5%
|
|
10261
|
Steeleye Stout
|
14.4
|
20
|
1.1%
|
|
10262
|
Chef Anton's Gumbo Mix
|
17
|
12
|
4.5%
|
|
1.
Highlight product(s) with cheapest price
2.
Highlight product(s) with highest price
3.
Calculate the total quantity of the product with Order ID=10260
4.
Count the products with Order ID=10255
5.
Count the products with Order ID=10255 and their quantities are greater
than 30 and less than 70
6.
Count the products with their names beginning with “ch”
7.
Count the products with their unit prices > 40 and their quantities
>30
8.
Calculate the average of unit prices of products with Order ID =10255
No comments:
Post a Comment