create table employees(
f_name text, -- f - first, l- last, b - before, d-department, no-number, e-employee
l_name text,
d_no int,
e_id int,
salary int
);
insert into employees(f_name, l_name,d_no,e_id,salary) values
("Neena","Kines",1,101,19000 ),
("Peter","Paul",2,123,120000 ),
("Mary","Pera",3,420,5000 ),
("Rogers","Kers",1,534,3000 ),
("Rahul","Maneul",3,456,8780 );
select * from employees;
select "______________________________________________";
select f_name, l_name,d_no,salary from employees where salary>8000;
select "______________________________________________";
select f_name, l_name, d_no from employees where l_name="Maneul";
select "______________________________________________";
select f_name, salary from employees order by f_name;
select "______________________________________________";
select sum(salary) from employees;
select "______________________________________________";
select avg(salary) from employees;
select "______________________________________________";
select * from employees where f_name="Neena" and e_id=101;
select "______________________________________________";
select count(f_name) from employees;
select "______________________________________________";
