create table employee

(

 id int(10) primary key,

 name varchar(50) not null,

 position varchar(30) not null,

 department varchar(30) not null,

 salary float,

 phone varchar(15) unique 

)





1. SELECT * from employee where phone like '019%'



2. SELECT * from employee where department='Finance' and salary between 10000 and 20000

   SELECT * from employee where department='Finance' and salary >= 10000 and salary <=20000



3. alter table employee add address varchar(100)

4. delete from employee where department='HR' and salary>20000

5. update employee set salary=salary*1.25