Database: boat_1
Question: How many red boats exist?
SQL:
SELECT count(*) FROM Boats WHERE color  =  'red'