Write the query that will produce a list of skills for a specific employee. This query requires a SQL JOIN between the SKILL and EMPLOYEE_SKILL tables.

B. SQL query to list all skills NOT assigned to a specific employee

Write the query that will produce a list of all skills NOT assigned to a specific employee. This query may be created using a number of techniques, such as using the IN keyword with a subquery.