Lynx Analytics interview question

Create an SQL query to join and access certain information.