Frage im Vorstellungsgespräch bei Retail Insight

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