List all the employees who were hired before 1982

Assignment Help Database Management System

Reference no: EM133055188

Learning Activity: Use the mi602_employee database that you previously installed in Module 2.2

Create queries for the following information requests:

List all the employees who were hired before 1982.

List the number of CLERKS employed. Give the result a meaningful heading.

Find the average salary for each job type and the number of people employed in each job.

List the employee names, the number of years that they have been with the company and the day on which they were employed.

List the employees with the lowest and highest salaries.

For each department list the department name, department number and the total salaries paid. Given the results meaningful headings.

Reference no: EM133055188

Questions Cloud

What is the name of the academic field : What does it mean? What does the term "usability" refer to? What is the name of the academic field?

List the names and the number of shipments : List the names and the number of shipments for all captains with more than one shipment. Order the list by the captains' names

Health care informatics and system breaches : Analyze three ways the HIMS failures impacted the organizations' operations and patient information protection, privacy, or personal safety.

Calculate the net sales revenue for the transaction : Question - Jolly uses the Perpetual Inventory System with Weighted-Average Cost Method. Calculate the Net Sales Revenue for the transaction

List all the employees who were hired before 1982 : Find the average salary for each job type and the number of people employed in each job and List all the employees who were hired before 1982

What is definition of multicultural workforce : What is your definition of multicultural workforce? Provide an example of a good program mission and vision that incorporates the learning needs of a multicultu

Productivity software options : Which productivity software options do you advise her to choose?

What is the opportunity cost in dollar value to the church : If the Church operates the homeless shelter, it receives a cash grant of $1,500 from the city. What is the opportunity cost in dollar value to the church

What is the differential revenue for leasing the truck : The truck originally cost $60,000 and has accumulated depreciation of $40,000. What is the differential revenue for leasing the truck

User Account

All Pages