PostgreSQL 13 cheat sheet

postgreSQL_cheatsheet.txt

SELECT COUNT(DISTINCT(*)) FROM _somewhere_

WHERE _something_ <= 12 AND _something2_ = '_word_'         
WHERE _something_ BETWEEN 8 AND 9
WHERE _something_ IN (0.99, 1.98, 1.99)
WHERE _something_ LIKE/ILIKE '_J%'

ORDER BY _something_ ASC, _something2_ DESC
LIMIT 5;

----------------------------------------------------------------------------------

MAX, MIN, AVG & ROUND, SUM

* GROUP BY - think blocks with same value as one block and operate aggregation function

SELECT col_1, col_2, aggregation_function(col_3) FROM table
GROUP BY aggregation_function(col_3)
ORDER BY ~ ~
~
HAVING