Help me please, need written in mysql

mysql> select * from Staff2; | staffNo | fName | iName | position | sex | DOB | salary | branchNo | superno | + | M | ABC1 | New | Enginer | Intern CC1 | Super | User DBA SA9 | 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 +- 9 rows in set (0.00 sec) F IF | M 3 3 3 3 3 | 2000-01-01 9000.00 | B002 | 1995-01-01 90000.00 B005 | 1970-02-19 | 9000.00 BOO7 1958-03-24 18000.00 | B003 1960-11-10 12000.00 | BOO3 1940-06-03 24000.00 | BO03 | 1945-10-01 | 30000.00 B005 1965-06-13 9000.00 | B005 | 1990-01-01 | 8000.00 | BOO2 | SL21 SG14 SG5 SG5 SG5 SL21 NULL SL21 | SL21 | M. mysql> select * from Branch; | branchNo | street | city | postcode | B002 BOO3 B004 B005 BOO7 56 Cover Drive | London | 163 Main Street | Glasgow 32 Manse Road | Bristol | 22 Deer Road | London | 16 Argyll Street | Aberdeen NW10 6 EU G11 9QX BS99 1NZ SW1 4EH AB2 3SU 5 rows in set (0.00 sec) 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 and Branch tables and the output column name should be (E_fName, E_pos, M_fName, M_pos)