-- create a table
CREATE table employees(
    emp_id INT  PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(50) NOT NULL,
    desig VARCHAR(50) NOT NULL DEFAULT 'Probation',
    dept VARCHAR(50) NOT NULL
);
INSERT into employees (emp_id,name,desig,dept) VALUES (101,'RAJU','Manager','Loan');
INSERT into employees (name,desig,dept) VALUES ('SHAM','CASHIER','CASH');
INSERT into employees (name,desig,dept) VALUES ('PAUL','ASSOCIATE','LOAN');
INSERT into employees (name,desig,dept) VALUES ('ALEX','ACCOUNTANT','LOAN');
INSERT into employees (name,desig,dept) VALUES ('VICTOR','ASSOCIATE','DEPOSIT');
#SELECT * FROm employees;
#SELECT emp_id, name FROM employees;
#SELECT emp_id, name FROM employees;
#SELECT emp_id,name FROM employees WHERE IN emp_id (101,103); # the postion of IN 
#SELECT * FROM employees WHERE emp_id IN (101, 103);
#SELECT emp_id, name,desig,dept FROM employees WHERE emp_id IN (101);
#SELECT emp_id, name FROM employees WHERE emp_id IN (101);
SELECT * FROM employees where emp_id = 101;
select * FroM employees;
#UPDATE employees SET dept = 'IT' where name = 'paul'; 
#select * FroM employees;

#DELETE FROM employees where emp_id =102;
#select * FroM employees;