Homework Help: programing

Posted by kenny on Monday, May 9, 2011 at 1:33pm.

3.Write a query to display the annual salary of all employees in department_id 20. Display the names in increasing order or salary.

4.Write a query to display the average salary of employees. Label the column as ' Average Salary.

5.Write a query to display the details of employees in the shipping' department who were hired after '01-JAN 1990' note that the query must use a join.

6.Write a query to display all unique department_id's in the employees table.

7.Write a query to display the detail of employees whose names start with 'A' and are in any one of the following departments; 20, 60, 100.

8.Write a query to display the employee last name, email, phone_number, hire_date, and department_name of all employees who earn a commission.

9.Write a query to find the earliest hire_date in each department in the Employees table.

10.Write a query to display the name, salary, department_name and job_title of all employees whose salary is greater than $10.000

SQL - MathMate, Monday, May 9, 2011 at 3:11pm
See suggestions in response at:

http://www.jiskha.com/display.cgi?id=1304962096

Answer this Question

Related Questions

programing - 5.Write a query to display the details of employees in the shipping...
programming - 1.Write a query to display the names of the employees that do not ...
programing - 10.Write a query to display the name, salary, department_name and ...
Statistics - The average annual salary of employees at Wintertime Sports was $28...
Computers C - Backgound The employees can be any one of the two types: 1) Full-...
C programming - Help would be grately apreciated on this problem thank you! ...
Programming - Design a program in pseudocode that calculates the amount of money...
computer science - I need to see if someone can hepl me with a c# programming ...
programmning code - Is this code right? Declare Integer days, counter = 1 ...
statistic - The time necessary to assemble a discount store display is normally ...

For Further Reading

First Name:
School Subject:
Answer: