lululemon interview question

General SQL questions about joins and filtering