The following (simple) database has been designed to keep track of customers and
ID: 3936439 • Letter: T
Question
The following (simple) database has been designed to keep track of customers and outstanding foans. Some sample data has been entered into the database Account: Account ype ame Rate Terms Private 10.00% 30 B Corporate 7.00% 60 C Preferred 5.00% 90 Customer: CustomerID FirstName LastName AccountType DateAcquired Barney 1123 Rubble 4/1/00 1234 Bugs Bunny B 4/4/DO 2134 Fred Flintstone B 12/1/99 2233 Herman Munster A 3/5/90 3324 George Jetson C 3/30/93 3333 Hiswife A 3131/93 Jane Loan: DistributionDate CustomerID LoanAmount LoanID $500.00 120 3/10/00 1234 121 4/4/00 2233 S10,000.00 122 $500.00 3/14/00 1234 123 $1,000.00 3/15/00 1123 1. Using the above tables, show exactly what would be produced by the following SQL statement: SELECT LastName, DateAcquired FROM Customer WHERE Accountlype "A ORDER BY LastName; 2. Using the above tables, show exactly what would be produced by the following SQL statement: SELECT LastName, DateAcquired FROM Customer INNER JOIN Loan WHERE AccountType "AExplanation / Answer
1. SELECT LastName, DateAcquired FROM Customer WHERE AccountType = "A" ORDER BY LastName;
HisWife 3/31/93
Munster 3/5/90
Rubble 4/1/00
2. SELECT LastName, DateAcquired FROM Customer INNER JOIN Loan ON Customer.CustomerID = Loan.CustomerID WHERE AccountType = "A" ORDER BY LastName;
Munster 3/5/90
Rubble 4/1/00
3. SELECT LastName, DateAcquired FROM Customer LEFT JOIN Loan ON Customer.CustomerID = Loan.CustomerID WHERE AccountType = "A" ORDER BY LastName;
HisWife 3/31/93
Munster 3/5/90
Rubble 4/1/00
4. Display a list of all customer first and last names in order by the date they were acquired, starting with the most recent.
SELECT FirstName, LastName FROM Customer ORDER BY DateAcquired DESC;