Exercise: 33

Get the ships sunk in the North Atlantic battle. Result set: ship.

Solution

SELECT ship
FROM outcomes
WHERE result='sunk'
        AND battle = 'North Atlantic'

References