Q
SQL QUEST
APPRENDS EN RÉSOLVANT
Missions
Leçons
Tarifs
Connexion
JOUER
ÉDITEUR SQL · SANDBOX POSTGRESQL 16
NOT EXISTS
SELECT s.name FROM sailors s WHERE s.crew_of = 'Crow' AND s.joined_year <= 1787 AND s.id IN (SELECT ca.sailor_id FROM crew_assignments ca JOIN voyages v ON v.id = ca.voyage_id GROUP BY ca.sailor_id HAVING count(DISTINCT v.ship_id) > 1) AND s.id IN (SELECT ca.sailor_id FROM crew_assignments ca JOIN voyages v ON v.id = ca.voyage_id JOIN ships sh ON sh.id = v.ship_id WHERE sh.name = 'Black Tide' AND v.year = 1787) AND s.id IN (SELECT ca.sailor_id FROM crew_assignments ca JOIN voyages v ON v.id = ca.voyage_id JOIN ships sh ON sh.id = v.ship_id WHERE v.year = 1788 AND sh.owner = 'Crow') -- livret officiel sans aucune disparition ? ;
Ctrl+Entrée pour interroger
Effacer
▶ INTERROGER
RÉSULTAT
SAILORS
SHIPS
CREW_ASSIGNMENTS
VOYAGES
SERVICE_RECORDS
Écris ta requête, puis interroge les registres.