Database Reference
In-Depth Information
SaleID
CustomerID
SaleDate
SubTotal
Tax
Total
1
1
12/14/2012
$3,500.00
$290.50
$3,790.50
2
2
12/15/2012
$1,000.00
$83.00
$1,083.00
3
3
12/15/2012
$50.00
$4.15
$54.15
4
4
12/23/2012
$45.00
$3.74
$48.74
5
1
1/5/2013
$250.00
$20.75
$270.75
6
5
$750.00
$62.25
$812.25
1/10/2013
7
6
1/12/2013
$250.00
$20.75
$270.75
8
2
$3,000.00
$249.00
$3,249.00
1/15/2013
9
5
1/25/2013
$350.00
$29.05
$379.05
10
7
2/4/2013
$14,250.00
$1,182.75
$15,432.75
11
8
2/4/2013
$250.00
$20.75
$270.75
12
5
2/7/2013
$50.00
$4.15
$54.15
13
9
2/7/2013
$4,500.00
$373.50
$4,873.50
14
10
2/11/2013
$3,675.00
$305.03
$3,980.03
15
2
2/11/2013
$800.00
$66.40
$866.40
Figure 2-47
Sample Data for the QACS
Database SALE Table
N.
Show the LastName, FirstName, and Phone of all customers who have had an order
with Total greater than $100.00. Use a join, but do not use JOIN ON syntax. Present
results sorted by LastName in ascending order and then FirstName in descending
order.
O.
Show the LastName, FirstName, and Phone of all customers who have had an order
with Total greater than $100.00. Use a join using JOIN ON syntax. Present results sorted
by LastName in ascending order and then FirstName in descending order.
P.
Show the LastName, FirstName, and Phone of all customers who who have bought
an Item named 'Desk Lamp'. Use a subquery. Present results sorted by LastName in
ascending order and then FirstName in descending order.
Q.
Show the LastName, FirstName, and Phone of all customers who have bought an Item
named 'Desk Lamp'. Use a join, but do not use JOIN ON syntax. Present results sorted
by LastName in ascending order and then FirstName in descending order.
R.
Show the LastName, FirstName, and Phone of all customers who have bought an
Item named 'Desk Lamp'. Use a join using JOIN ON syntax. Present results sorted by
LastName in ascending order and then FirstName in descending order.
Search WWH ::
Custom Search