Write the SQL queries for the following questions. Use aliases to appropriately name any output that is labeled by default as Expr1 or No Column Name. You

must take a screen shot of the SQL statement and the results and paste that into a Word document and then drop the document into the digital drop box on

Blackboard.
Questions

1. The total salary of all employees in the MIS department.
2. The number of employees in the current year who got a performance rating of 3 or more or a salary increase of 5% or more.
3. The SSN, name, and salary of employees in the Marketing department who joined the firm after 12/31/2003 and earn more than $75,000.
4. The SSN, name, dept, salary of the highest earner in the whole firm.
5. The SSN, Name, Department, Salary, performance rating, and date joined of workers who joined before 2007 but not including those who are either in the

MIS department or those who earn more than $100,000 and joined after 2004.

6. The maximum salaries of employees grouped by department and position.
7. The number of workers in each department who joined the firm in 2010 or after.
8. The average performance ratings given by supervisor. The query should return the supervisor’s SSN, name, and average performance rating and should be

ordered by average performance rating in ascending order.