Exercise: 14

For the ships in the Ships table that have at least 10 guns, get the class, name, and country.

Solution

SELECT ships.class, ships.name, classes.country
FROM ships
	LEFT JOIN classes ON ships.class = classes.class
WHERE classes.numGuns >= 10