1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Relational Databases in SQL

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.