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
Product ID
Name
Color
Cost
Price
SubcategoryID
ModellID
Sell StartDate
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
Red
187.1571
337.22 14
9
2001-07-01 00:00:00.000
2003-06-30 00:00:00.000
3
727
LL Road Frame-Red, 52 Red
187.1571
337.22 14
9
2001-07-01 00:00:00.000
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
Red
187.1571
337.22 14
9
2001-07-01 00:00:00.000
2003-06-30 00:00:00.000
6
730
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
7
759
Road-650 Red. 58
Red
486.7066
782.99 2
30
2001-07-01 00:00:00.000
2003-06-30 00:00:00.000
8
760
Road-650 Red, 60
Red
486.7066
782.99 2
30
2001-07-01 00:00:00.000
2003-06-30 00:00:00.000
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
16 768
Road-650 Black, 44
Black
486.7066
782.99 2
30
2001-07-01 00:00:00.000
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
Black
598.4354
1079 1
21
2002-07-01 00:00:00.000
2003-06-30 00:00:00.000
21 787
Mountain-300 Black, 44
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
Black
598.4354
1079 1
21
2002-07-01 00:00:00.000
2003-06-30 00:00:00.000
23 789
Road-250 Red, 44
Red
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
