SQL Notebook I Wish I Had Crafted Sooner in My Coding Path

SELECT * FROM table; SELECT ... FROM ... WHERE condition SELECT ... FROM ... WHERE condition GROUP BY field; SELECT ... FROM ... ORDER BY field1, field2 ASC; SELECT ... FROM ... WHERE condition ORDER BY field1, field2 DESC; SELECT ... FROM ... LIMIT 10; SELECT DISTINCT field1 FROM ... table; SELECT DISTINCT field1, field2 FROM ... table; 

field1 = value1 t1.field = t2.field field1 <> value1 field1 LIKE 'value _ %' field1 IS NULL field1 IS NOT NULL field1 IS IN (value1, value2) field1 IS NOT IN (value1, value2) condition1 AND condition2 condition1 OR condition2 

MAX() MIN() AVG() CONCAT() STRING_AGG() 

WITH CTE_table_name AS ( query );