Manhattan Associates Interview Question

Example SQL queries.