programing

posted by .

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 -

    See suggestions in response at:

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

  • programing -

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

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Programming

    Design a program in pseudocode that calculates the amount of money a person would earn over a period of time if their salary is one penny the first day, and then doubles each day. The program should ask the user for the number of days. …
  2. programming

    1.Write a query to display the names of the employees that do not have any department_id. 2. Write a query to display the names, salary and job_id of employees in department_id 40, 60 and 80. Display the name as a single column and …
  3. programing

    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 …
  4. programing

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

    The average annual salary of employees at Wintertime Sports was $28,750 last year. This year the company opened another store. Suppose a random sample of 18 employees had an average annual salary of $25,810 with standard deviation …
  6. QBASIC, Computers

    The following is a list of salaries of the six employees in a certain company: Name Salary T. Angel $43,000 F. Smith $31,000 K. Johnston $22,000 P. Miner $18,000 C. Altman $27,000 A. Lu $19,000 Read a single dimension array for name …
  7. programming

    write a program that creates a list of employees objects of size n entered from user using list interface and a list class implementation and display all employees in list and print employee name with minimum salary and remove employee …
  8. programming concepts

    Input a list of employee names and salaries stored in parallel arrays. The sal-aries should be floating point numbers in increments of 100. For example, a salary of $ 36,000 should be input as 36.0 and a salary of $ 85,900 should be …
  9. Programming

    1.Do the planning and write an algorithm to solve the following problem. Prepare test data for the example to test all possibilities and draw a trace table. Sam works at a coffee company where all the employees receive a bonus of R700, …
  10. visual basic programming

    Write a program that accepts salaries of 25 employees into an array into an array and display the following i. Sum of all salaries ii. All salaries below 500 iii. All salaries above 3200 iv. Average salary v. Message if the salary …

More Similar Questions