CREATE TABLE employees (
    emp_id INT PRIMARY KEY AUTO_INCREMENT,
    fname VARCHAR(50) NOT NULL,
    lname VARCHAR(50) NOT NULL,
    desig VARCHAR(50) NOT NULL DEFAULT 'Probation',
    dept VARCHAR(50) NOT NULL,
    salary INT NOT NULL DEFAULT 25000
);
-- Inserting 10 tuples into the employees table
INSERT INTO employees (fname, lname, desig, dept, salary) VALUES 
('John', 'Doe', 'Manager', 'HR', 30000),
('Jane', 'Smith', 'Developer', 'IT', 40000),
('Paul', 'Adams', 'Associate', 'Sales', 27000),
('Lucy', 'Brown', 'Cashier', 'LOAN', 23000),
('Ravi', 'Kumar', 'Developer', 'IT', 35000),
('Mina', 'Patel', 'Accountant', 'Finance', 49000),
('Sam', 'Wilson', 'HR Specialist', 'HR', 32000),
('Tina', 'Jones', 'Sales Executive', 'loan', 26000),
('Alex', 'Morris', 'Team Lead', 'IT', 42000);

#find employees whose salary are between 30000 t0 40000;
# select fname,salary from employees where salary between 30000 and 40000; 
# find the employees whose first name start with 'R' or 'S';

#select fname from employees where fname LIKE 'R%' or  fname LIKE'A%';
#find employees whose salary = 25000 and dept shoulde be 'cash'

#select * from employees where salary = 23000 AND dept = 'LOAN';

#find employees from following designation 
Select *  from employees WHERE desig IN ('Developer','Team Lead', 'associate');
#manager, lead and associate