-- 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;