SELECT col1, col2
FROM table
JOIN table2 ON table1.col = table2.col
WHERE condition
GROUP BY column_name
HAVING condition
ORDER BY col1 ASC|DESC;

SELECT DISTINCT product_name
FROM product;

SELECT product_name
FROM product
WHERE price BETWEEN 50 AND 100;

SELECT product_name
FROM product
WHERE category IN ('Electronics','Furniture');

SELECT product_name
FROM product
WHERE product_name LIKE '%Desk%';

INSERT INTO tablename(col1,col2) VALUES(val1,val2);
UPDATE tablename SET col1=val1 WHERE condition;
DELETE FROM tablename WHERE condition;

CREATE TABLE tablename (
 column_name data_type
);

ALTER TABLE tablename ADD COLUMN columnname datatype;

CREATE INDEX indexname ON tablename(cols);
DROP INDEX indexname;

CASE
 WHEN name='John' THEN 'Name John'
 ELSE 'Unknown'
END

WITH queryname AS (
 SELECT col1,col2 FROM firsttable
)
SELECT * FROM queryname;

RANK() OVER (PARTITION BY gender ORDER BY fees_paid)

SELECT *
FROM employee
WHERE salary = (
 SELECT MAX(salary)
 FROM employee
);