MySQL [Need in 10 hours]

Please check inside

This assignment is about a hospital. It uses SQL 2008 R2 data base. I need help ASAP.

{ Name}

ITCO333 – Unit 4

{date}

Note: Unit 2’s assignment provided the specifications for the EMPLOYEES and DEPARTMENTS tables.

UPDATE THE EMPLOYEES TABLE AND GIVE ALL EMPLOYEES MAKING LESS THAN $10 PER HOUR A 5% INCREASE.

1. Paste SQL as text

2. Include a screen shot of SQL

3. Include a screen shot of the results (there must be some results).

LIST ALL RECORDS/FIELDS IN THE EMPLOYEES TABLE IN ORDER OF THE EMPLOYEE’S LAST NAME.

1. Paste SQL as text
2. Include a screen shot of SQL

3. Include a screen shot of the results (there must be some results).

LIST ALL RECORDS/FIELDS IN THE EMPLOYEES TABLE IN ORDER OF THE DEPARTMENT NAME.

Note: Department name is not in the Employees table.

1. Paste SQL as text

2. Include a screen shot of SQL
3. Include a screen shot of the results (there must be some results).

LIST EMPLOYEE NAMES, HOURLY PAY RATE AND DEPARTMENT NAME FOR EMPLOYEES MAKING BETWEEN (AND INCLUDING) $10 AND $30 PER HOUR.

Note: Department name is not in the Employees table.
1. Paste SQL as text
2. Include a screen shot of SQL
3. Include a screen shot of the results (there must be some results).

WHAT IS THE TOTAL ORGANIZATION PAYROLL ASSUMING EACH EMPLOYEE WORKS 40 HOURS PER WEEK?

Note: Do not permanently change the data in your tables to arrive at the answer.