Humana interview question

Write SQL commands to do [X type of] query?