Liquidline Interview Question

Basic SQL, including UNION joins, aggregate functions, dynamic SQL preferred