SQL Cheat Sheet

Create Table:

        
CREATE TABLE table_name (
    column1 datatype1 constraint1,
    column2 datatype2 constraint2,
    ...
);
        
    

Insert Data:

        
INSERT INTO table_name (column1, column2, ...)
VALUES (value1, value2, ...);
        
    

Select Data:

        
SELECT column1, column2, ...
FROM table_name;
        
    

Filtering Data:

        
SELECT column1, column2, ...
FROM table_name
WHERE condition;
        
    

Update Data:

        
UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
        
    

Delete Data:

        
DELETE FROM table_name
WHERE condition;
        
    

Sorting Data:

        
SELECT column1, column2, ...
FROM table_name
ORDER BY column1 ASC|DESC;
        
    

Aggregate Functions:

        
SELECT COUNT(column) AS count_alias
FROM table_name;

SELECT SUM(column) AS sum_alias
FROM table_name;

SELECT AVG(column) AS average_alias
FROM table_name;

SELECT MIN(column) AS min_alias
FROM table_name;

SELECT MAX(column) AS max_alias
FROM table_name;
        
    

Joins:

        
SELECT column1, column2, ...
FROM table1
JOIN table2 ON table1.column = table2.column;
        
    

Group By:

        
SELECT column1, COUNT(column2) AS count_alias
FROM table_name
GROUP BY column1;
        
    

Having:

        
SELECT column1, COUNT(column2) AS count_alias
FROM table_name
GROUP BY column1
HAVING count_alias > 5;
        
    

Constraints:

        
CREATE TABLE table_name (
    column1 datatype1 NOT NULL,
    column2 datatype2 UNIQUE,
    column3 datatype3 PRIMARY KEY,
    column4 datatype4 REFERENCES table2(column),
    ...
);