The manager of sales wants to regularly track the number of rental properties under management by the department. She asked you to create a view for staff who manage properties for rent, that includes the branch at which they work (branchNo), their staff number (staffNo), and a count of the number of properties they manage. Group the results by branchNo and staffNo. The name of the view is StaffPropCnt. Name, save the view and run it.

b) Using the view StaffPropCnt, develop a query which counts the number of properties managed by each member of staff at branch office B003. Order results by StaffNo. The name of the query is QueryView, save the query and run.