Question: Consider the employee table and write down SQL for the following queries. 1 . Show everything from the Employee Table. 2 . Show the SUM

Consider the employee table and write down SQL for the following queries.
1. Show everything from the Employee Table.
2. Show the SUM of AGE of all the employees.
3. Show the Name of the Employee and MAX Salary of the employee.
4. Show the Name of the Employee and MIN Salary of the employee.
5. Show the Average (AVG) Salary of the employee.
6. Show the Number (COUNT) of employee.
7. Show the Number (COUNT) of employee and Average (AVG) Salary of the employee in two
columns. Rename the columns using Alias (AS).
8. Show the Standard Deviation (STD) of the AGE of the Employees.
9. Show the Standard Deviation (STD) of the Salary of the Employees.
10. Show the Variance (VAR) of the AGE of the Employees.
11. Show the Variance (VAR) of the Salary of the Employees.
12. Show the name of the Employee, who is getting the highest salary.
13. Show the name of the Employee, who is getting the lowest salary.
14. Show the name of the Employees who are getting Salary higher than their Average Salary.
 Consider the employee table and write down SQL for the following

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 Databases Questions!