Devam Ediyor

492551 SQL needed it last friday prefer under 25 dollars

Building on the previous database, write queries using the SQL SELECT

statement. Make sure to illustrate the salaries before and after the

modifications (Select *).

„h Sort all employees by payroll, in descending order.

„h Calculate the total payroll of exempt and non-exempt employees

(before & after the adjustments are made).

„h Choose a specific job_title and increase the salary of all individuals

in this category by 0.5%.

„h Increase the remaining employee¡¦s salaries by 2.5%.

„h Add a ¡¥Senior Director¡¦ position to the Job_title table.

„h You discovered that the newly created position should not have

been added to your database. As a result, this information needs to

be deleted from the table.

The HR Department recently submitted a change request. They want the

following information extracted from the database.

„X Calculate the number of exempt and non-exempt employees

there are, by job title. The results should be sorted in

descending order.

„X Calculate the average salary for all employees.

„X In one query, calculate the average, minimum and maximum

salary for exempt employees.

„X Calculate the difference between the maximum and minimum

salaries for the non-exempt employees.

„X Calculate the minimum salary for exempt employees and the

maximum salary for non-exempt employees.

Using a CASE statement, illustrate:

„h Showing the Employee name and job title, list exempt employees as

¡¥Salaried¡¦ and non-exempt employees as ¡¥Hourl y¡¦.

Beceriler: Her şey Kabul, SQL, Web Sitesi Yönetimi

Daha fazlasını görün: sure payroll, salary exempt, salaries, payroll statement, payroll position, non exempt position, non exempt employees, non exempt employee, non exempt, make dollars, it director, illustrate name, hr position, hr director, exempt salary, exempt position, exempt employees, exempt employee, anything dollars, 5 dollars, payroll job, payroll number, total it, sql queries, payroll hr

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

Proje NO: #2238463



please see the PM

1 gün içinde 30$ USD
(1 Değerlendirme)