Exercise: 44

Find all ship names beginning with the letter R.

Solution

SELECT ship
FROM (
	SELECT name AS ship
	FROM ships
	UNION
	SELECT ship
	FROM outcomes
) all_ships
WHERE all_ships.ship LIKE 'R%'

References

  1. LIKE (Transact-SQL)