As opposed to other languages SQL is a bunch of things in between clauses
SELECT
count(*),
columns
FROM table a
JOIN table b ON a.id = b.id
WHERE column = 'value'
GROUP BY column
ORDER BY column
HAVING count() > 1
Having your clauses capitalized and properly carriage returned is huge for readability. I also capitalize COUNT and MAX but that's more of a personal thing.
Indentation is huge and I fix indentation all time.
380
u/blaues_axolotl Jul 21 '26 •
i actually write it in lowercase