Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following Employee table and write down SQL for the following queries. 1 . Show all the rows and all the columns from the

Consider the following Employee table and write down SQL for the
following queries.
1. Show all the rows and all the columns from the Employee Table.
2. Show all the rows and all the columns except for the ID from the
Employee Table.
3. Show the Name of the employee whose AGE is more than 22 but less
than 30.
4. Show the name of the Employee, who is getting the highest salary.
5. Show the name of the Employee, who is getting the lowest salary.
6. Show the Number (COUNT) of employees.
7. Show all the employees information whose Salary is NOT between
40000 and 70000.
8. Show the employees who are NOT from Delhi and Mumbai.
9. Show all the employees name and address of the employee.
10.Show the name of the Employees who are getting Salary higher than their average salary.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

50 Tips And Tricks For MongoDB Developers Get The Most Out Of Your Database

Authors: Kristina Chodorow

1st Edition

1449304613, 978-1449304614

More Books

Students also viewed these Databases questions

Question

What is the specific purpose of an acceptable use policy?

Answered: 1 week ago