What is the name of the school whose namesake is John F. Kennedy?
CREATE TABLE table_55987 (
    "School's name" text,
    "School's namesake" text,
    "Year opened" text,
    "Principal" text,
    "Mascot" text
)
SELECT "School's name" FROM table_55987 WHERE "School's namesake" = 'john f. kennedy'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What is the name of the school whose namesake is John F. Kennedy? ### Input: CREATE TABLE table_55987 (
    "School's name" text,
    "School's namesake" text,
    "Year opened" text,
    "Principal" text,
    "Mascot" text
) ### Response: SELECT "School's name" FROM table_55987 WHERE "School's namesake" = 'john f. kennedy'