Language SQL

Create a view vHW1_5_xxxx listing the first name, position and their manage first names and positions for all female staff in Assistant position. The output header needs to distinguish between staff and manger.

Here are the tables

+---------+-------+--------+------------+------+------------+----------+----------+-----------+

| staffNo | fName | lName | position | sex | DOB | salary | branchNo | managerNo |

+---------+-------+--------+------------+------+------------+----------+----------+-----------+

| SA9 | Mary | Howe | Assistant | F | 1970-02-19 | 9000.00 | B007 | SG14 |

| SG14 | David | Ford | Supervisor | M | 1958-03-24 | 18000.00 | B003 | SG5 |

| SG37 | Ann | Beech | Assistant | F | 1960-11-10 | 12000.00 | B003 | SL21 |

| SG5 | Susan | Brand | Manager | F | 1940-06-03 | 24000.00 | B003 | SG14 |

| SL21 | John | White | Manager | M | 1945-10-01 | 30000.00 | B005 | XYZ1 |

| SL41 | Julie | Lee | Assistant | F | 1965-06-13 | 9000.00 | B005 | XYZ1 |

| XYZ1 | Huang | Austin | CEO | M | 1970-01-01 | 40000.00 | B002 | NULL |

+---------+-------+--------+------------+------+------------+----------+----------+-----------+