Use of SQL including: SELECTing columns from a table, Aggregates Part 1: COUNT, SUM, MAXMIN, Aggregates Part 2: DISTINCT, GROUP BY, HAVING, JOINs, ANSI-89 and ANSI-92 syntax, UNION vs UNION ALL, NULL handling, Subqueries, WITH syntax: Subquery FactoringCTE, and Views   This role requires some on-site work in Las Vegas, NV