CREATE TABLE `book` (`book_id` INT NOT NULL AUTO_INCREMENT , `book_name` VARCHAR(50) NOT NULL , `book_price` INT(5) NOT NULL , `book_writter` VARCHAR(50) NOT NULL , PRIMARY KEY (`book_id`))

INSERT INTO `book` (`book_id`, `book_name`, `book_price`, `book_writter`) VALUES ('101', 'Bangla', '100', 'Sakib'), (NULL, 'English', '150', 'Tahmeed'), (NULL, 'Arabic', '200', 'Tamim')

SELECT *
FROM orderlist

SELECT DISTINCT Invoice
FROM orderlist

SELECT *
FROM orderlist
WHERE id = 25

SELECT *
FROM orderlist
WHERE Id = 10 AND Invoice = 'abcxyz'

SELECT *
FROM orderlist
WHERE Id = 10 OR Invoice = 'abcxyz'

SELECT *
FROM orderlist
WHERE NOT RefTrx = 'AAE0M3JW8Q'

SELECT *
FROM orderlist
ORDER BY Id ASC

SELECT *
FROM orderlist
ORDER BY Id DESC

INSERT INTO orderlist (`Id`,`Invoice`,`RefTrx`)
VALUES (1000, 'testInvoiceId', 'testRefTrx');

UPDATE orderlist
SET RefTrx = 'updatedRefId', Invoice = 4.1254
WHERE id = 5;

DELETE
FROM orderlist
WHERE Id = 7;

SELECT AVG(Amount)
FROM paystation
WHERE Payment_Method = 'bKash';

SELECT MIN(Amount)
FROM paystation
WHERE Payment_Method = 'bKash';

SELECT MAX(Amount)
FROM paystation
WHERE Payment_Method = 'bKash';

SELECT SUM(Amount)
FROM paystation
WHERE Payment_Method = 'bKash';

SELECT COUNT(Amount)
FROM paystation
WHERE Payment_Method = 'bKash';

SELECT *
FROM paystation
WHERE Customer_Mobile LIKE '015%';

SELECT *
FROM paystation
WHERE Customer_Mobile LIKE '%015%';

SELECT *
FROM paystation
WHERE Customer_Mobile LIKE '0_';

SELECT * 
FROM paystation
WHERE Payment_Method IN ('Nagad', 'Rocket');

SELECT * 
FROM paystation
WHERE Payment_Method IN ('Nagad', 'Rocket');

SELECT * 
FROM paystation
WHERE Payment_Method IN (SELECT Payment_Method FROM anothertable);

SELECT * 
FROM paystation
WHERE Amount BETWEEN 0 AND 505

SELECT Amount AS 'Temp table title'
FROM paystation
WHERE 1

SELECT table1.id, table2.name
FROM table1
INNER JOIN table2 ON table1.id = taabl2.id

SELECT table1.id, table2.name
FROM table1
LEFT JOIN table2 ON table1.id = taabl2.id

SELECT table1.id, table2.name
FROM table1
RIGHT JOIN table2 ON table1.id = taabl2.id

SELECT table1.id, table2.name
FROM table1
CROSS JOIN table2 ON table1.id = taabl2.id

SELECT id FROM table1
UNION
SELECT id FROM table2

ALTER TABLE paystation
ADD name varchar(255)

ALTER TABLE paystation
DROP COLUMN name;

ALTER TABLE paystation
MODIFY COLUMN Action varchar(255);