SQLTeam.com | Weblogs | Forums

Exercise

For each country, determine the battles in which the ships of this country did not participate.
Result set: country, battle.

Classes(class, type, country, numGuns, bore, displacement)
Ships(name, class, launched)
Battles(name, date)
Outcomes(ship, battle, result)

INSERT INTO battles (name, "date") VALUES ('#Cuba62a', timestamp'1962-10-20 00:00:00');
INSERT INTO ships (name, class, launched) VALUES ('California', 'Tennessee', 1921);
INSERT INTO classes (class, type, country, numguns, bore, displacement) VALUES ('Bismarck', 'bb', 'Germany', 8, 15, 42000);
INSERT INTO outcomes (ship, battle, result) VALUES ('Bismarck', 'North Atlantic', 'sunk');