Using Microsoft Access Friendly Sql Please Write Sql Code Determine Following Questions 1 Q37225558

Using Microsoft Access Friendly SQL, please write SQLcode to determine the following questions:

1) Show the number of properties that are managed by eachbranch.

2) Display property numbers based on the rent in descendingorder.

3) Find out the properties that are managed by a supervisor.

4) How many positions are in Staff table?

Table Relationships:

Registration 0oclientNo Client clientNo fName IName telNo Branch branchNo street 0O branchNo staffNo dateJoined postcode Viewing clientNo property viewDat Staff staffNo fName IName position sex DOB salary branchNO PropertyForRe.. PrivateOwner propertyNo street

OR

 

OR