CREATE TABLE table_55987 ("School's name" CLOB, "School's namesake" CLOB, "Year opened" CLOB, "Principal" CLOB, "Mascot" CLOB)

What is the name of the school whose namesake is John F. Kennedy?
SELECT "School's name" FROM table_55987 WHERE "School's namesake" = 'john f. kennedy'
SELECT "School's name" FROM "table_55987" WHERE "School's namesake" = 'john f. kennedy'