sql just learned

union

nullif (e1, e2) if e1 ==2 return null else return e2

if (expr, iftrue, iffalse)

[not] exists (query)

true if query returns rows

count(expr) counts when expr is not null expression can be anything