HMS Consulting interview question

Sent me a table and has to do different queries