ZoomInfo interview question

Joining multiple tables Creating sub queries and CTE