“Your given a complex database diagram, asked how to perform certain joins on the tables.
“The logic question at the beginning. The question was, "You're in a room with 3 switches. In the next room over are 3 lights. You can't see the lights in the next room. You can flip the switches as…”