CREATE TABLE employee( LName varchar(255), FName varchar(255), City varchar(255), Age INT, Salary INT);
Expand Requery Edit Explain Profiling Database : lab2 Queried time : 8:27:2
SELECT * FROM `employee`
INSERT INTO employee(LName,FName,City,Age,Salary) VALUES('Rubayad','Hasan','Noahkhali',55,250);
SELECT * FROM `employee`
INSERT INTO employee(LName,FName,City,Age,Salary) VALUES('Hasan','Rummon','Dhaka',60,5000);
SELECT * FROM `employee`
SELECT * FROM `employee`;
INSERT INTO employee(LName,FName,City,Age,Salary) VALUES('Hasan','Ruman','Dhaka',60,50000);







INSERT INTO employee(LName,FName,City,Age,Salary)
VALUES('Hasan','Rummon','Dhaka',60,5000);



CREATE TABLE employee( LName varchar(255), FName varchar(255), City varchar(255), Age INT, Salary INT);
SELECT * FROM `employee`
INSERT INTO employee(LName,FName,City,Age,Salary) VALUES('Rubayad','Hasan','Noahkhali',55,250);
SELECT * FROM `employee`
INSERT INTO employee(LName,FName,City,Age,Salary) VALUES('Hasan','Rummon','Dhaka',60,5000);
SELECT * FROM `employee`
SELECT * FROM `employee`;
INSERT INTO employee(LName,FName,City,Age,Salary) VALUES('Hasan','Ruman','Dhaka',60,50000);
SELECT * FROM employee;
Expand Requery Edit Database : lab2 Queried time : 8:43:13
INSERT INTO employee(LName,FName,City,Age,Salary) VALUES ('Karp','Rabin','Dhaka',60,50000),('Sabbir','Johnny','Dhaka',65,1000);
SELECT * FROM `employee`
SELECT * FROM `employee`
SELECT * FROM `employee`
SELECT * FROM `employee`
SELECT DISTINCT City FROM employee;
SELECT Age,Salary FROM employee WHERE LName='Rummon';
SELECT Age,Salary FROM employee WHERE LName='Rabiul';
SELECT * FROM employee WHERE Age < 60;
SELECT * FROM employee ORDER BY LName DESC;
SELECT * FROM employee WHERE City='Dhaka' AND Salary > 500;
SELECT * FROM employee WHERE City = 'Noahkhali' AND (LName LIKE 'R%' OR LName LIKE 'Ru%');
SELECT * FROM employee WHERE NOT City = 'Noahkhali';
SELECT * FROM employee;
SELECT * FROM employee WHERE LName NOT LIKE 'R%';
SELECT * FROM employee WHERE Salary BETWEEN 250 AND 5000;
SELECT * FROM employee WHERE Age BETWEEN 60 AND 61;
SELECT * FROM employee WHERE Salary NOT BETWEEN 10 AND 5000;
SELECT * FROM employee WHERE NOT Salary > 5000;
SELECT * FROM employee WHERE NOT Salary < 5000;
SELECT * FROM employee WHERE NOT Age < 65;
SELECT * FROM employee WHERE City IN ('Noahkhali');
SELECT * FROM employee WHERE City IN ('Noahkhali');
SELECT * FROM employee WHERE City IN ('Noahkhali','Dhaka');
SELECT * FROM employee WHERE LName IN ('Rubayad');
SELECT * FROM employee WHERE LName NOT IN ('Rubayad');