Gallagher interview question

basic questions about structure of SQL databases and queries