Instructions:
You will use the database we created in the lab on Thursday. Write the sql 
queries in a file. The filename should be your lastname1.sql, e.g. 
Kanoulas1.sql. To create the file you can use pico,vi,emacs or any other 
editor you know. To check the sql statements get in the sql environment, 
typing sqlplus at the unix prompt,etc. At the SQL prompt type 
start <file name>
e.g. start Kanoulas1.sql
What you will send to me is the sql file. I will post another file with 
instruction of how to send the file.

Write in SQL the following questions:

1. If the number of owners living in Glasgow is more than 2 then list their first and last name 
(if not then nothing will appear as a result - empty table).

2. List all branch numbers of branch offices that have more than 1 member of staff and the average 
salary of the staff is between $12000 and $13000.

3. What is the number of flats and the maximum number of rooms that a flat has in each city?

4. Are there any two properties that were viewed at the same day?If yes then list the view date 
else the empty table should appear.

5. How many managers are males?

6. List all cities in which the average rent per room is greater than $100.

7. What is the number of all different types of properties with 4 rooms?

8. If 10% taxes are imposed on the amount of money an owner earns by renting his/her houses, 
what are the taxes each one of the owners will pay if he/she rent all his/her houses?

9. What is the average salary for each position in each branch?

10. In how many branches the minimum salary is less than 10000?

11. What is the minimum rent clients are willing to pay for each type of property?

12. How many clients registered in 2000?

13. How many staff members first name is the same as their last name? 
(say last name is John and first name is John)

14. How many staff members didn't give their date of birth to the company?

15. Are there (count them) any owners that the 3rd character of their last name is 'r' and 
the fifth is 'h'?