Simple SQL Commands - Property Rental

1. Give the details of all viewings.

2. Give the address, pcode, telephone and fax number of the branch where
Jane Wee works.

3. Provide the name of the renter, the address and postal code of the rental
property, the date of viewing and the comments indicated of all viewings.

4. Provide owner's name of all rental properties.

5. Based on the renter's preference type, list all the rental_properties which
he/she can potentially view.
6. How many staff have salaries greater than $3500?
7. Find the average salary of each branch.
8. Count the total number of rental properties which each owner has.

9. List the name of the staff in charge, full address and rental prices of HDB
properties.

10. How many staff work for this rental company?

11. List the number of viewings and the identifier of the renters have made
more than 1 viewing?

12. Give the average rent which the renters in the data base are willing to
pay.

13. List the name and positions of staff who are earning more than the
average salary.

14. List the name of staff who are in charge of rental_properties as well as
those who are not in charge of any rental properties.

15. List the rental properties which have been viewed as well as those which
have not been.

16. Provide the area of the branch, name of the owner, name of staff in
charge and all details of rental_properties.

17. Count the number of staff who have salaries greater than the average
salary of the company.

18. List staff name, position and age and the areas they work in.

19. Find the HDB properties which have rental prices greater than the
average rental amount for HDB properties.

20. Provide the name of staff members who are sales executives and
the address, area and pcode of the branches which they work in.