Devam Ediyor

504267 Week 4 and Team Edward

Week 4

1) Use the database and tables from last week's assignment to write the following SQL queries .

Requirement Check Comments

a) Write a SQL query to increase all employees' salaries with the selected EEO-1 classification by 10% Use Update and include a join with Job_title.

b) Write a SQL query to increase all employees' salaries by 5%.

Use Update.

c) Write a SQL query that to select an employee from the Employee table and delete that employee. Note: To delete or update a specific record you must specify the records primary key

2) Use the database and tables from last week's assignment to write SQL statements that do the following:

Requirement Check Comments

a) Calculate the average salary for all employees.

b) Calculate the maximum salaries for exempt and non-exempt employees.

Use Group By and include a join with Job_title

c) Calculate the maximum salary for all employees.

d) Calculate the minimum salaries for exempt and non-exempt employees.

Use Group By and include a join with Job_title

e) Calculate the minimum salary for all employees

Kudler

• Define the SQL database. Done

• Load the SQL database with data from the chart of accounts spreadsheet. Done

• Prepare test data and load it into the SQL database. Done

• Create account number query.

• Test query.

Beceriler: Her şey Kabul, Excel, SQL

Daha fazlasını görün: use update include join job_title, salary exempt, salaries, non exempt employees, non exempt employee, non exempt, exempt salary, exempt non exempt, exempt employees, exempt employee, define exempt, create a table chart, eeo, load excel, classification excel, excel sql query, excel sql create, write sql queries, query spreadsheet, load average, prepare salary excel, calculate load, kudler week, excel database update, sql test number

İşveren Hakkında:
( 4 değerlendirme )

Proje NO: #2250191

Seçilen:

djain01

as discussed.

2 gün içinde 50$ USD
(104 Değerlendirme)
6.0