-- SELECT statement
SELECT column1, column2
FROM table_name
WHERE condition;
-- INSERT statement
INSERT INTO table_name (column1, column2)
VALUES (value1, value2);
-- UPDATE statement
UPDATE table_name
SET column1 = value1, column2 = value2
WHERE condition;
-- DELETE statement
DELETE FROM table_name
WHERE condition;
-- JOIN
SELECT column1, column2
FROM table1
JOIN table2 ON table1.column_name = table2.column_name;
-- GROUP BY
SELECT column1, COUNT(column2)
FROM table_name
GROUP BY column1;
-- ORDER BY
SELECT column1, column2
FROM table_name
ORDER BY column1 ASC;
-- DISTINCT
SELECT DISTINCT column_name
FROM table_name;
-- WHERE clause operators
= Equal
<> Not equal
> Greater than
< Less than
>= Greater than or equal
<= Less than or equal
BETWEEN Between an inclusive range
LIKE Search for a pattern
IN To specify multiple possible values
-- LIMIT
SELECT column1, column2
FROM table_name
LIMIT 10; -- limits the result to 10 rows