Gallagher Interview Question

basic questions about structure of SQL databases and queries