A company uses the following table to store its employee data Employee < EmpID, EmpName, StartDate, Salary> The company...

Transcribed Image Text:

A company uses the following table to store its employee data Employee< EmpID, EmpName, StartDate, Salary> The company decided to raise the salary of employees who started before 2010 by 10%, those who started between 2010 and 2020 (inclusive) by 8% and the employees who started after 2020 by 5% of their respective averages. Create the database Insert some records (at least 3 records from each group (before 2010, between 2010 and 2020, and after 2020) Use aggregate functions to find the average of each group Write update queries to update the salaries ● In this exercise you are using different queries to find the average salary of each group, and apply them to increase the employee salaries. In our next lecture you will learn to combine them as main/subqueries. Deliverable Submit the list of queries that you used and screenshots of the outputs when you run the queries

Answer rating: 100% (QA)

Creating the Database and Inserting Records You can create the database and insert records using SQL commands Here s how you can do it Create the Empl View the full answer