programing

posted by .

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

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. English

    anyone know where my other question went regarding the mythology sources?
  2. written communication

    I need a example on how to write a Persuasive message and a negative message. Marie or Ann or whoever, http://www.jiskha.com/search/search.cgi?
  3. Computer

    An employee at xyz Recruiters would like to query the Recruiter table. She has created a query and entered the fields she wants to display in the result in the design grid. Now, she enters the criteria. 3. What would the employee enter …
  4. computer science

    If all the hub and authority scores are initialized to 1, what is the hub/authority score of a node after one iteration?
  5. 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 …
  6. programing

    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 …
  7. 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
  8. SQL

    Display a list of all instructors, showing their ID, name, and the number of sections that they have taught. Make sure to show the number of sections as 0 for instructors who have not taught any section. Your query should use an outerjoin, …
  9. structured query language math

    Display a list of all instructors, showing their ID, name, and the number of sections that they have taught. Make sure to show the number of sections as 0 for instructors who have not taught any section. Your query should use an outerjoin, …
  10. 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, …

More Similar Questions