CREATE TABLE table_27949 ("meas. num." FLOAT, "passed" CLOB, "YES votes" FLOAT, "NO votes" FLOAT, "% YES" CLOB, "Const. Amd.?" CLOB, "type" CLOB, "description" CLOB)

How yes votes were there for measure 4?
SELECT MAX("YES votes") FROM table_27949 WHERE "meas. num." = '4'
SELECT MAX("YES votes") FROM "table_27949" WHERE "meas. num." = '4'