##::CREATE INSERT::
CREATE TABLE information(
    id INT,
    name VARCHAR(10),
    dept VARCHAR(10),
    phone VARCHAR(21),
    PRIMARY KEY(id)

);
:::INSERT:
INSERT INTO information()
VALUES('1','rakib','cse','01710'),
('2','bepul','ice','015'),
('3','laila','history','018');
##NOT::
SELECT DISTINCT name ,id,dept
FROM information
WHERE NOT dept = 'cse';
##Min,MAX,avg,SUM,COUNT::
SELECT name,MIN(price) AS smallPrice
FROM product2
SELECT name,MAX(price) AS bigPrice
FROM product2
SELECT name,SUM(price) AS sumPrice
FROM product2
SELECT name,AVG(price) AS AVGPrice
FROM product2
SELECT name,COUNT(id) AS Noid
FROM product2

##Order::
SELECT name ,dept
FROM information
ORDER BY name;
SELECT name ,dept
FROM information
ORDER BY name DESC;

##Like::
WHERE CustomerName LIKE 'a%'    Finds any VALUES that START WITH "a"
WHERE CustomerName LIKE '%a'    Finds any VALUES that END WITH "a"
WHERE CustomerName LIKE '%or%'  Finds any VALUES that have "or" IN any POSITION
WHERE CustomerName LIKE '_r%'   Finds any VALUES that have "r" IN the SECOND POSITION
WHERE CustomerName LIKE 'a__%'  Finds any VALUES that START WITH "a" AND are at least 3 characters IN LENGTH
WHERE ContactName LIKE 'a%o'    Finds any VALUES that START WITH "a" AND ends WITH "o"


##In::
SELECT name ,dept
FROM information
WHERE dept IN('cse','eng','ice');

##Between::
SELECT name,price AS fixedprice
FROM product2
WHERE price BETWEEN 50 AND 100;



##Joins::

SELECT information.name,dept,product2.name,price
FROM information,product2;