Question

1. What customer addresses are on a "Lane or Ln?"
   
2. What's the address to all businesses that were incorporated after Jan 1, 2000?
   
3. How many individuals were born before 1970?
   
4. What's the average available and pending balance for all accounts at each Branch? (use Group by)
   
5. Which accounts have a difference between their Available and Pending Balance?
   
6. How many employees does Paula Roberts Supervise?
   
7. Who are the employees work that work at each Branch?

SQL Schema

https://textuploader.com/1dty2

Answer 1

1.

Select Address from Customer where Address Like 'Lane' or Address Like 'Ln';

2.

Select State_ID from Business where Incorp_Date >To_Date('01-JAN-2000','DD-MON-YYYY');

3.

Select * from Individual where Year(Birth_Date) < 1970;

4.

Select Open_Branch_ID, AVG(Avail_Balance), AVG(Pending_Balance) from ACCOUNT group by Open_Branch_ID;

5.

Select * from Account where Avail_Balance - Pending_Balance >0;

6.

Select Count(Emp_ID) from Employee where Superior_Emp_ID = ( Select Emp_ID from Employee where First_Name = 'Paula' and Last_Name = 'Roberts';

7.

Select * from Employee where Assigned_Branch_ID = ALL(Select Branch_ID from Branch);

Do ask if any doubt. Please up-vote.