HackerOne Interview Question

Live Coding SQL exercise: Given a set of multiple tables, construct a query that will join them together and produce a report with a specified format