The following simple database has been designed to keep trac

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 \"A

Solution

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%\' ;