Staff 2 Table

Branch Table

12. (10 pts) Create a view vHW1_#_xxxx listing all the cities and the male staff names working there. Ifa city does not have any staff, that city should be still in the output. You should use Staff2 and Branch table and the output column name should (city_name, staff_name). The staff_name should combine fname and lname with a space in between. staffNo | fName | IName | position | sex | DOB | salary | branchNo | superno | ABC1 CCl SA9 SG14 SG37 SG5 SL21 SL41 XYL | New | Enginer | Intern IM | Super | User | DBA | M | Mary | Howe | Assistant IF | David | Ford | Supervisor | M Ann | Beech | Assistant | F | Susan | Brand | Manager | F | John | White | Manager IM | Julie | Lee | Assistant IF | New Tester | Assistant |M | 2000-01-01 | 9000.00 | B002 | 1995-01-01 | 90000.00 | B005 | 1970-02-19 | 9000.00 | B007 | 1958-03-24 | 18000.00 | B003 | 1960-11-10 | 12000.00 | B003 | 1940-06-03 | 24000.00 | B003 | 1945-10-01 | 30000.00 | B005 | 1965-06-13 | 9000.00 | B005 | 1990-01-01 | 8000.00 | B002 | SL21 | SG14 | SG5 | SG5 | SG5 | SL21 | NULL | SL21 | SL21 | | branchNo | street | city | postcode +-- | B002 | 56 Cover Drive | London | NW10 6EU | B003 | 163 Main Street | Glasgow | Gil 90X | B004 | 32 Manse Road | Bristol | BS99 INZ | B005 | 22 Deer Road | London | SW 4EH | B007 | 16 Argyll Street | Aberdeen | AB2 3SU