Chubb Insurance interview question

Joins, DDL DML, Basic Queries