EVERSANA interview question

Given a small table, write SQL queries that corresponded to the question, ranging in difficulty.