Pergunta de entrevista da empresa Amazon

Not very difficult but I messed up a question regarding a complex SQL query. I used a union instead of an intersection.