GEP interview question

MVC Architecture, Sql Queries with joins