TABLE : teacher
i)To display the entire table
ii)To show all the information about the teacher of Computer Department.
iii) To display the names of teachers who get a salary of at least 25000
iv)To display the list of distinct departments in the table.
v)To list the names of male teachers who are in the math department.
vi)To display teacher’s name , salary ,age for non-History teachers only.
vii)To display the Name, Salary , and Tax(10% of salary) of the teacher.
viii)To display the details of Math and Computer teachers.
ix)To display the name of teachers who are either above 40 years of age or have a salary of at least 30000
x)To display the names of the teachers with no department assigned.
CREATE AND INSERT
create database if not exists mydb1;
use mydb1;
create table teacher(
No int primary key auto_increment,
Name varchar(20) not null,
Age numeric(2) check(age between 20 and 70),
Department varchar(20),
DOJ date,
Salary numeric(7),
Sex varchar(1) check(Sex in ('M','F')));
insert into teacher(Name,Age,Department,DOJ,Salary,Sex) values
('Jugal',34,'Computer','1997-01-10',12000,'M'),
('Sharmila',31,'History','1998-03-24',20000,'F'),
('Sandeep',32,'Math','1996-12-12',30000,'M'),
('Sangeeta',35,'History','1999-07-01',40000,'F'),
('Rakesh',42,'Math','1997-09-05',25000,'M'),
('Shyam',50,NULL,'1998-06-27',30000,'M'),
('Shiv Om',44,'Computer','1997-02-25',21000,'M'),
('Shalaka',33,'Math','1997-07-31',20000,'F');
select * from teacher;
QUERIES
i)select * from teacher;
ii)select * from teacher where Department = 'Computer';
iii)select * from teacher where salary>25000;
iv)select distinct Department from teacher;
v)select * from teacher where Department = 'Math' and Sex = 'M';
vi)Select Name,Salary,Age from teacher where Department != 'History';
vii)Select Name,Salary,10/100*Salary as Tax from teacher;
viii)Select * from teacher where Department = 'Math' or Department = 'Computer';
ix)select * from teacher where age>40 or salary>=30000;
x)Select * from teacher where Department is NULL;