Lynx Analytics Interview Question

Create an SQL query to join and access certain information.