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

how many cultivars are of the semi double flower type ?
SELECT COUNT("name") FROM table_203_699 WHERE "flower type" = 'semi-double'
SELECT COUNT("name") FROM "table_203_699" WHERE "flower type" = 'semi-double'