Reference no: EM13850928

1) How many employees work for subsidiary 001?

2) After sorting via the "order by clause" the employees that work for subsidiary 001 by last_name, print the top 15 employees names.

3) Build a query that has a calculated field of budgeted_hours_per_pay * hourly_base_pay for the employees that work at subsidiary 002 - only print the employee's name, budgeted_hours_per_pay, hourly_base_pay and the calculated field.

4) Build a query that will count the number of employees at each subsidiary who work in a given department (given by the Job_Class_Code value). In other words, we want to create a group total on a department. The query should print the subsidiary_name, job_class_code and a count of how many employees work in that particular department at that particular subsidiary.

5) Create a query that updates any active employees that have 0 or null for his/her budgeted_hours_per_pay and change it to 1.23. Write a query that prints out which employees were affected.

6) Across all subsidiaries, which employee(s) earns the most money per hour? What is the least someone makes (after you've run #5, no one should be at 0). What is the average amount earned?

7) Print the employees who were born prior to 1/1/1970.

8) Produce a query that shows the number of departments that each subsidiary has.

9) Show, but don't run, how to write a query which would delete any employee that lives in Clio.

10) This is a tough one (you might not be able to do this) - print the names of the employees that work for more than one subsidiary.