Liquidline interview question

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