KNAPP North America interview question

Basic SQL query using joins