Exercise: 36

List the names of lead ships in the database (including the Outcomes table).

Solution

SELECT class
FROM classes
WHERE class IN (
	SELECT name
	FROM ships
	UNION
	SELECT ship
	FROM outcomes
)

References