Write SQL statement

Be sure to identify the question number for each of your responses.

Table Employee fname text, Iname text, dob date, salary numeric, skillcode numeric

Table Skill

skillcode numeric, skillname text

An employee can have only a single skill

Display the name of all the employees who have a skill. In addition to the name, also display the skillname. Do not display the employees who don't have a skill

Display the number of employees for each of the different skills. Be sure to also display the skillname

isplay the employees who are not tied to any skills using the minus operator

Display the employees who are not tied to any skills using the not in operator

Display the employees who are not tied to any skills using the not exists clause

Display each employee and the skills that they have. Display their first name and the skillname. If they don't have a skill, display $\text{'}$No Skill'. If they do have a skill but there is no description, then display $\text{'}$no description'