EVERSANA Interview Question

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