Learning SQL — The SQL Cheatsheet — Part II

COUNT

SUM

MAX/MIN

AVERAGE

ROUND

GROUP BY I (one column)

GROUP BY II (two columns)

HAVING

JOIN ON

INNER JOIN

Inner join from Codecademy

LEFT JOIN

Left join from Codecademy

PRIMARY KEY vs FOREIGN KEY

CROSS JOIN

Cross Join

UNION

Union

WITH

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store