Devam Ediyor

503373 Data Changes and SQL Statements - 3

(1)Using the data from last week, display all data from both tables to provide a baseline for the remainder of the queries. The output from the Jobs_Title table query should be ordered by the Job Title. The output from the Employee query should be ordered by Last Name.

(2)Increase all employees' salaries with a specific EEO-1 classification by 10 percent.

(3)Increase all employees' salaries by 5 percent.

(4)Choose an employee and yourself from the Employee table and delete these two employees with one command.

(5)Provide a query that proves that those two were in fact, deleted. Hint: Use COUNT.

(6)Calculate the average salary for all employees.

(7)Calculate the maximum salaries for exempt and non-exempt employees. Hint: A single query is required and it will the 'GROUP BY' clause.

(8)Calculate the maximum salary for all employees.

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

(10)In single query display the average age, maximum age, and minimum age of all of the employees. Make sure to label each column output so as to know which value goes with which calculation.

Provide the SQL and screen shot of the results of each of the above.

Beceriler: Her şey Kabul, Veri Girişi, SQL

Daha fazlasını görün: salary for data entry, salary exempt, salaries, non exempt employees, non exempt employee, non exempt, exempt salary, exempt non exempt, exempt employees, exempt employee, command group, average salary for data entry, average salary data entry, statements, sql queries, sql data, sql and c, eeo, data query, data entry SQL , baseline, sql required, queries sql, sql entry, choose employee employee table delete employee

İşveren Hakkında:
( 9 değerlendirme ) Houston, United States

Proje NO: #2249297