1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| CREATE VIEW VILLEDEPARTMISSION
AS SELECT idMission, villeDepart, COUNT(*) AS totalVilleDepart
FROM MISSION
GROUP BY idMission, villeDepart;
CREATE VIEW VILLEARRIVEEMISSION
AS SELECT idMission, villeArrivee, COUNT(*) AS totalVilleArrivee
FROM MISSION
GROUP BY idMission, villeArrivee;
SELECT villeDepart, villeArrivee
FROM MISSION
GROUP BY villeDepart, villeArrivee
HAVING COUNT(*) = (SELECT MAX(totalVilleDepart + totalVilleArrivee) FROM VILLEDEPARTMISSION
JOIN MISSION ON MISSION.idMission = VILLEDEPARTMISSION.idMission
JOIN VILLEARRIVEEMISSION ON VILLEARRIVEEMISSION.idMission = MISSION.idMission); |
Partager