For this hw, you will add (your own) data to tables you'd create, based on your database design from HW1, then write SQL queries to run on those tables :)

Q3 (1 point). The owners have asked you to create a new table, after you'd built the original db - this is a simple 'capabilities' table, with just two columns: EMPLOYEE ID, SKILL. With this table, they hope to have, in a single place, what each employee (staff, surgeons... everyone) can do, eg. throw a party, file taxes, administer injections, extract teeth, talk to the press... [each employee would pick from a giant list of tasks, one or more of the items - this is to prevent variations and typos].

Write a query that will pick out only the employees who can do every task in a table such as the one below:

File taxes Meet the press Organize spring cleaning Do teeth cleaning Reorder inventory 

Why do this? The owners want to plan a 'light week' that is staffed with a limited number of employees who can do all the above, and rotate tasks - while giving the rest of the staff, paid time off (the ones who come to work get 1.5x pay for that week - cool!).