Question d’entretien chez Sherwin-Williams

Difference between all types of SQL joins. Explain what certain code does (SQL & JavaScript). Difference between Union and Union All. Why this role, typical behavioral STAR questions.