WHAT IS THE DEATH WHEN BIRTH DATE IS 2 AUGUST 1424?
CREATE TABLE table_49974 (
    "Name" text,
    "Heir of" text,
    "Birth" text,
    "Ceased to be Duke of Girona" text,
    "Death" text
)
SELECT "Death" FROM table_49974 WHERE "Birth" = '2 august 1424'
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 DEATH WHEN BIRTH DATE IS 2 AUGUST 1424? ### Input: CREATE TABLE table_49974 (
    "Name" text,
    "Heir of" text,
    "Birth" text,
    "Ceased to be Duke of Girona" text,
    "Death" text
) ### Response: SELECT "Death" FROM table_49974 WHERE "Birth" = '2 august 1424'