Exercise

Join all the tables together

In this last exercise, your task is to find the university city of the professor with the most affiliations in the sector "Media & communication".

For this,

  • you need to join all the tables,
  • group by some column,
  • and then use selection criteria to get only the rows in the correct sector.

Let's do this in three steps!

Instructions 1/3

undefined XP
    1
    2
    3

Join all tables in the database (starting with affiliations, professors, organizations, and universities) and look at the result.