Pergunta de entrevista da empresa ADP

sql based on scenarios such as giving example tables?