MindGate Solutions Interview Question

Sql query and few basic things