Accelogix interview question

One simple algorithm question, several questions about SQL queries, and a few concerning interpreting their "in house" software