CREATE VIEW

Create view of staff who manage properties for rent, including branch number they work at, staff number, and number of properties they manage.


 CREATE VIEW StaffPropCnt (branchNo, staffNo, cnt)
 AS SELECT s.branchNo, s.staffNo, COUNT(*)
       FROM Staff s, PropertyForRent p 
       WHERE s.staffNo = p.staffNo
       GROUP BY s.branchNo, s.staffNo;