Publicis Sapient interview question

SQL Entity-Relationship definition, Explain SQL Joins,