Format of SQL Select Command:

SELECT
<fieldname>, <fieldname>,<fieldname>operator <fieldname>, function(<fieldname>), <fieldname> as newname = column
FROM
<tablename>, <tablename> newname (could put JOIN inbetween files and then use ON)
WHERE
<condition> and/or <condition> = fewer rows
GROUP BY
<fieldname> = make summary rows; grouped field must be in select fieldnames
HAVING
<condition on group> and /or <condition on group> = fewer summary rows

Aggregate Functions: avg, min, max, sum, count, least, greatest

Conversion Functions: to_char; to_number, to_date, translate, decode

String Functions: || (for concatenation), lpad, rpad, ltrim, rtrim, lower, upper, initcap, length, substr, instr

Numeric functions: +,1, *, / abs, ceil, floor, mod, power, sqrt

Date: sysdate, next_day, add_months, last_day, months_between, least, greatest, round, trunc.