Zoom
4 of 4
Paper No: 1
[1 mark] write a query to select all products that have a sell end date in 2003
Results Messages
ProductID Name
Color Cost
Price
SubcategoryID ModelID
SellStart Date
Sell End Date
1
725
LL Road Frame-Red. 44
Red
187.1571 337.22 14
و
2001-07-01 00:00:00.000
2003-06-30 00:00:00.000
2
726
LL Road Frame-Red. 48 LL Road Frame-Red. 52
Red
187.1571 337.22 14
2001-07-01 00:00:00.000 2003-06-30 00:00:00.000 2001-07-01 00:00:00.000
3
727
Red
187.1571 337.22 14
9
2003-06-30 00:00:00.000
4
728
LL Road Frame Red, 58
Red
187.1571 337.22 14
9
2001-07-01 00:00:00.000
2003-06-30 00:00:00.000
5
729
LL Road Frame Red. 60 LL Road Frame-Red, 62
Red
187.1571 337.22 14
9
2001-07-01 00:00:00.000 2003-06-30 00:00:00.000
6
730
Red
187.1571 337.22 14
9
2001-07-01 00:00:00.000
2003-06-30 00:00:00.000
7
759
Road-650 Red. 58 Road-650 Red, 60
Red
486.7066 782.99 2 486.7066 782.99 2
30
2001-07-01 00:00:00.000 2003-06-30 2001-07-01 00:00:00.000
00:00:00.000 2003-06-30 00:00:00.000
8 760
Red
30
9 761
Road-650 Red, 62
Red
486.7066 782.99 2
30
2001-07-01 00:00:00.000
2003-06-30 00:00:00.000
10 762
Road-650 Red, 44
Red
486.7066 782.99 2
30
2001-07-01 00:00:00.000
2003-06-30 00:00:00.000
11 763
Road-650 Red. 48
Red
486.7066 782.99 2
30
2001-07-01 00:00:00.000 2003-06-30 00:00:00.000
12 764
Road-650 Red. 52
Red
486.7066 782.99 2
30
2001-07-01 00:00:00.000 2003-06-30 00:00:00.000
13 765
Road-650 Black, 58
Black 486.7066 782.99 2
30
2001-07-01 00:00:00.000
2003-06-30 00:00:00.000
14 766
Road-650 Black, 60
Black 486.7066 782.99 2
30
2001-07-01 00:00:00.000
2003-06-30 00:00:00.000
15 767
Road-650 Black, 62
Black 486.7066 782.99 2
30
2001-07-01 00:00:00.000 2003-06-30 00:00:00.000 2001-07-01 00:00:00.000
16 768
Road-650 Black, 44
Black 486.7066 782.99 2
30
2003-06-30 00:00:00.000
17 769
Road-650 Black, 48
Black 486.7066 782.99 2
30
2001-07-01 00:00:00.000 2003-06-30 00:00:00.000
18 770
Road-650 Black, 52
Black 486.7066 782.99 2
30
2001-07-01 00:00:00.000
2003-06-30 00:00:00.000
19 785
Mountain-300 Black, 38
Black 598.4354 1079 1
21
2002-07-01 00:00:00.000
2003-06-30 00:00:00.000
20 786
Mountain-300 Black, 40 Mountain-300 Black, 44
Black
598.4354 1079 1
21
2002-07-01 00:00:00.000 2003-06-30 00:00:00.000
21 787
Black
598.4354 1079 1
21
2002-07-01 00:00:00.000
2003-06-30 00:00:00.000
22 788
Mountain-300 Black, 48
23 789
Road-250 Red, 44
Black 598.4354 1079 1
Red
21
2002-07-01 00:00:00.000 2003-06-30 00:00:00.000
1518.7 2443 2
26
2002-07-01 00:00:00.000
2003-06-30 00:00:00.000
Picture 2.1
Question 3:
[1 mark] write a query to get products that are put at the A shelf. The result includes: product
id, name, price, quantity, shelf in descending order of Quantity as follows:
+ 100%
Close
