Xignite Interview Question

Gave an SQL table and asked me to make different queries