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!
Bu egzersiz
Introduction to Relational Databases in SQL
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Join all tables
SELECT *
FROM affiliations
JOIN ___
ON affiliations.professor_id = professors.___
JOIN organizations
ON affiliations.organization_id = ___.___
JOIN ___
ON professors.___ = universities.id;