Question: Create a view vHW1_#_xxxx listing the first name, position and their manager's first names and positions for all male staff who work at London. The output header needs to distinguish between staff and manager. You should use Staff2 table and the output column name should be (E_fName, E_pos, M_fName, M_pos).

Staff2 Table:

Branch Table:

Thank you

11. (10 pts) Create a view vHw1_#_xxxx listing the first name, position and their manage first names and positions for all male staff who work at London. The output header needs to distinguish between staff and manger. You should use Staff2 table and the output column name should be (E_ Name, E_pos, M_fName, M_pos). | sex | DOB | salary | branchNo | superno ! mysql> select * from Staff2; | staffNo | fName | lName | position ABC1 New | Enginer | Intern CC1 Super | User | DBA SAS Mary | Howe | Assistant SG14 David | Ford | Supervisor SG37 Ann | Beech | Assistant SG5 Susan | Brand | Manager SL21 John | white | Manager SL41 Julie Lee | Assistant | XY1 | New | Tester | Assistant | 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 | F | M F | M 9 rows in set (0.00 sec )