Pergunta de entrevista da empresa Retail Insight

How SQL joins work. As well as difference between having/where.