Retail Insight interview question

Basic SQL knowledge (For example, inner vs left joins)