lululemon Interview Question

General SQL questions about joins and filtering