4) For each Vancouver branch count the number of properties managed by their staff. Sequence the output by highest to lowest count. 5) Count the number of different property types located in Toronto that are currently leased. 6) List property details for detached homes (DT) in Toronto with at least 3 rooms and a monthly rent under $3,000. Sequence by monthly rent cheapest first. 7) List the details of all leases for properties managed by staff in Toronto branches that will expire anytime in 2020. Sequence by expiry date. 8) List the details for owners with more than 4 townhouse (TH) Toronto properties. 9) List the client number and name of all clients registered with a Vancouver based branch. 10) For employees of Toronto branches list the details of the highest paid employee. 11) List the names of the staff who are managing any semi detached (SM) Toronto properties. Show each staff member once. 12) List the details for staff who manage townhouse (TH) properties that have a current lease. Show each staff only once. Sequence alphabetical by name. 13) List the details for detached (DT) properties with a monthly rent higher than the average for that property type. 14) List in alphabetical name order the details for clients who would be interested in a detached home with a monthly rent of no more than $1,800. 15) List the details for staff who manage more than 4 properties