Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SQLs: Write down SQL statements to , 1 . Create the above mentioned Employees Table. 2 . Insert the records shown above. 3 . Show

SQLs: Write down SQL statements to,
1. Create the above mentioned Employees Table.
2. Insert the records shown above.
3. Show all the records (all the columns and all the rows) as output.
4. Show the DISTINCT department names of this office.
5. Show all the employees hired after 2022-12-31.
6. Show all the information of the employees whose salary is higher than 80000.
7. Show all the information of the employees whose salary is less than 75000.
8. Show all the information of the employees whose salary is between 80000 and 90000.
9. Show all the information of the employees who are from Sales department.
10. Show first name of the employees who are from Sales department and salary is higher
than 75000.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions