Question: Get to know the HR database, its tables, and their contents. Show the SQL query and the output. Use INNER JOIN for multiple table query.

Get to know the HR database, its tables, and their contents. Show the SQL query and the output.
Use INNER JOIN for multiple table query.
1- Display details of jobs where the minimum salary is greater than 10000.
2- Display the first name and join date of the employees who joined between 2002 and
2005.
3- Display first name and join date of the employees who is either IT Programmer or Sales
Man.
4- Display details of employee with ID 150 or 160.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!