CREATE TABLE table_203_699 (id NUMBER, "name" CLOB, "parentage" CLOB, "size" CLOB, "flower colour" CLOB, "flower type" CLOB)

what is the only plant with deep red flower color ?
SELECT "name" FROM table_203_699 WHERE "flower colour" = 'deep red'
SELECT "name" FROM "table_203_699" WHERE "flower colour" = 'deep red'