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