Ships(name, class, launched)
Outcomes(ship, battle, result)
Find the names of all ships whose name consists of three or more words.
SELECT name FROM Ships WHERE name LIKE '% % %';
It still returns every tuple in the database, I have no idea where to go from here, any help is greatly appreciated.
This post has been edited by Atli: 13 September 2012 - 09:34 PM
Reason for edit:: Please use [code] tags when posting code.