Database Reference
In-Depth Information
Figure 2-48
Sample Data for the QACS
Database SALE_ITEM Table
ItemPrice
SaleID
SaleItemID
ItemID
1
1
1
$3,000.00
1
2
2
$500.00
2
1
3
$1,000.00
3
1
4
$50.00
4
1
5
$45.00
5
1
6
$250.00
6
1
7
$750.00
7
1
8
$250.00
8
1
9
$1,250.00
8
2
10
$1,750.00
9
1
11
$350.00
10
1
19
$5,000.00
10
2
21
$8,500.00
10
$750.00
3
22
11
1
17
$250.00
12
1
24
$50.00
13
1
20
$4,500.00
14
1
12
$3,200.00
14
2
14
$475.00
15
1
23
$800.00
S.
Show the LastName, FirstName, and Phone of all customers who have bought an Item
named 'Desk Lamp'. Use a combination of a join and a subquery. Present results sorted
by LastName in ascending order and then FirstName in descending order.
T.
Show the LastName, FirstName, and Phone of all customers who have bought an Item
named 'Desk Lamp'. Use a combination of a join and a subquery that is different from
the combination used for question S. Present results sorted by LastName in ascending
order and then FirstName in descending order.
Search WWH ::
Custom Search