SQL features

select from select

join, left join

union, union all, intersect

distinct, order by, group by, having

first skip last rows limit fetch

sum, max, min, avg, list/listagg

= <> > >= < <= + - * / mod || in between like not like starting with and or

exists, any, some, all

subselects

cast, decode, iif, case, coalesce

pivot, rollup, cube