Database Reference
In-Depth Information
InvoiceNumber
ItemNumber
Item
Quantity
UnitPrice
2013001
1
Blouse
2
$3.50
2013001
2
Dress Shirt
5
$2.50
2013001
3
Formal Gown
2
$10.00
2013001
4
Slacks-Mens
10
$5.00
2013001
5
Slacks-Womens
10
$6.00
2013001
6
Suit-Mens
1
$9.00
2013002
1
Dress Shirt
10
$2.50
2013003
1
Slacks-Mens
5
$5.00
2013003
2
Slacks-Womens
4
$6.00
2013004
1
Dress Shirt
7
$2.50
2013005
1
Blouse
2
$3.50
2013005
2
Dress Shirt
2
$2.50
2013006
1
5
Blouse
$3.50
2013006
2
Dress Shirt
10
$2.50
2013006
3
Slacks-Mens
10
$5.00
2013006
4
Slacks-Womens
10
$6.00
2013007
1
Blouse
2
$3.50
2013008
1
Blouse
3
$3.50
2013008
2
Dress Shirt
12
$2.50
2013008
3
Slacks-Mens
8
$5.00
Figure 2-40
Sample Data for the
MDC Database
INVOICE_ITEM Table
2013008
4
Slacks-Womens
10
$6.00
2013009
1
Suit-Mens
3
$9.00
S. Show the LastName, FirstName, Phone, and TotalAmount of all customers who have
had an order with an Item named 'Dress Shirt'. Use a combination of a join and a sub-
query. Present results sorted by LastName in ascending order and then FirstName in
descending order.
T. Show the LastName, FirstName, Phone, and TotalAmount of all customers who have
had an order with an Item named 'Dress Shirt'. Also show the LastName, FirstName,
and Phone of all other customers. Present results sorted by LastName in ascending
order, and then FirstName in descending order.
Search WWH ::




Custom Search