Lithic Interview Question

SQL: A sample table was provided and asked to make efficient joins to fetch certain information.