CREATE TABLE table_19872699_1 (flag VARCHAR, builder VARCHAR)

Which flag was on the Green Marine's boat?
SELECT flag FROM table_19872699_1 WHERE builder = "Green Marine"
SELECT "flag" FROM "table_19872699_1" WHERE "Green Marine" = "builder"