The following (simple) database has been designed to keep track of customers and
ID: 3934726 • 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)
lastname DateAcquired
HisWife 3/31/93
Rubble 4/1/00
**************************************************************************************************
4) select Firstname,Lastname from customer order by DateAcquired desc;
*************************************************************************************************
5)select Firstname,Lastname from customer where lastname like 'M%' or lastname like 'N%' ;