SQL

Instructions: For the ERD shown below, import the create and insert files $($attached below$)$ into your MySQL environment $($e$.$g$.,$ XAMPP$)$ before you attempt

this assessment.

Once the database is imported, you will need to write and run MySQL statements for given query in each question.

Your answers of this assessment will be based on your MySQL statements and$/$or the output tables.

File attachments:

Mock Lab D create.txt darr

Mock Lab D insert.txt darr

Figure: Entity Relationship Diagram $($ERD$)$ for Department database.

Note: You do not need to download and import the database files for each question. You import only once, then write and run query for each question.

Query: Update Staff Salaries up by $20\%$ increase. Then, find the staff whose salaries are more than $$100,000.$

While looking at your output table, answer to the following questions:

Instructions: For each question, write your answer in one number or word only.

Question

Your answer

a$)$ How many staff do have salary more than $$100,000?$

Question Blank $1$ of $2$

type your answer...

b$)$ Write the first name of a staff from your output table?

Question Blank $2$ of $2$

type your answer...