Question One

$2$ Marks

Consider the following EMPLOYEE relation from a company database. Write SQL queries to answer the following questions:

$\backslash$table$[[$Emald$,$Name,Salary,Gender,Address$],[123,$Sarah,$50000,$Female,Jeddah$],[234,$Mohamed,$45000,$Male,Riyadh$],[376,$Ahmed,$70000,$Male,Jeddah$],[498,$Maryam,$10000,$Female,Jeddah$],[555,$Muna,$30000,$Female,Riyadh$]]$

$1-$ Retrieve the count of Female Employees.

$2-$ Retrieve the average Salary of all Employees.

$3-$ Delete the record of the Employee named "Muna".

$4-$ Insert a new employee into the table.