I NEED HELP WITH 2 AND 3 PLEASE The following simple databas

I NEED HELP WITH #2 AND #3 PLEASE

The following (simple) database has been designed to keep track of customers and outstanding loans. Some sample data has been entered into the database Using the above tables, show exactly what would be produced by the following SQL statement: Using the above tables, show exactly what would be produced by the following SQL statement: Using the above tables, show exactly what would be produced by the following SQL statement: For each of the following questions, write the complete SQL syntax that will produce the results specified. Do not include any extra SQL clauses that are not required by the question (for example, do not sort your results unless this has been specifically stated or implied by the requested data). Make sure any calculated results are labeled appropriately. Display a list of all customer first and last names in order by the date they were acquired, starting with the most recent. Display a list of customer first and last names for customers whose last names begin with either M or N. For each type of account, show the number of customers we have with that account type.

Solution

Here are the solutions for the 2 problems you asked for:

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