Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create database emp1;
- use emp1;
- create table employee(e_id int primary key,e_name varchar(50),age int,salary int);
- insert into employee(e_id, e_name, age, salary) values
- (1, 'Ani', 30, 50000),
- (2, 'Bob', 25, 60000),
- (3, 'Charlie', 35, 55000),
- (4, 'David', 28, 50000),
- (5, 'Eva', 30, 70000);
- select count(e_name) as Total_Employees from employee;
- select max(age) as Max_Age from employee;
- select min(age) as Min_Age from employee;
- select e_name, salary from employee order by salary asc;
- select salary, count(*) as Num_Of_Employees from employee group by salary;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
