QUERY SQL

EX no 3: 

Queries using aggregate functions(COUNT,AVG,MIN,MAX,SUM),Group by,Orderby. Employee(E_id, E_name, Age, Salary) 1. Create Employee table containing all Records E_id, E_name, Age, Salary. 2. Count number of employee names from employeetable 3. Find the Maximum age from employee table. 4. Find the Minimum age from employeetable. 5. Find salaries of employee in Ascending Order. 6. Find grouped salaries of employees.

Create Employee Table

CREATE TABLE Employee (

    E_id INT PRIMARY KEY,

    E_name VARCHAR(50),

    Age INT,

    Salary DECIMAL(10,2)

);

(Insert some sample records)

Count Number of Employee Names

SELECT COUNT(E_name) AS Total_Employees

 FROM Employee;

Find Maximum Age

SELECT MAX(Age) AS Maximum_Age

FROM Employee;

Find Minimum Age

SELECT MIN(Age) AS Minimum_Age

FROM Employee;

 Find Salaries in Ascending Order

SELECT Salary

FROM Employee

ORDER BY Salary ASC;

 Find Grouped Salaries of Employees

(Group employees having same salary and count them)

SELECT Salary, COUNT(*) AS Number_of_Employees

FROM Employee

GROUP BY Salary;