CREATE TABLE table_7203 ("Rank" CLOB, "Name" CLOB, "Height m / ft" CLOB, "Floors" FLOAT, "Year" FLOAT)

What is the number of floors that have years under 2008 and were named Guinness Tower?
SELECT COUNT("Floors") FROM table_7203 WHERE "Year" < '2008' AND "Name" = 'guinness tower'
SELECT COUNT("Floors") FROM "table_7203" WHERE "Name" = 'guinness tower' AND "Year" < '2008'