Exercise: 42

Find the names of ships sunk at battles, along with the names of the corresponding battles.

Solution

SELECT ship, battle
FROM outcomes
WHERE result = 'sunk'

References