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.
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).
EXAMPLE: WHERE CLAUSE USING COMPARISON OPERATORS
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).
EXAMPLE: ORDER BY CLAUSE
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).
EXAMPLE: JOINS
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).
EXAMPLE: AGGREGATION
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).
0 comments