Table: prince_of_girona
Columns: name
heir_of
birth
ceased_to_be_duke_of_girona
death

Question: WHAT IS THE DEATH WHEN BIRTH DATE IS 2 AUGUST 1424?
SQL: SELECT "death" FROM prince_of_girona WHERE "birth" = '2 august 1424'

Question: WHAT IS THE Ceased to be Duke of Girona THAT HAS PETER IV?
SQL: SELECT "ceased_to_be_duke_of_girona" FROM prince_of_girona WHERE "heir_of" = 'peter iv'

Question: WHAT IS THE BIRTH DATE THAT HAS Ceased to be Duke of Girona OF 21 NOVEMBER 1582?
SQL: SELECT "birth" FROM prince_of_girona WHERE "ceased_to_be_duke_of_girona" = '21 november 1582'

Question: WHAT IS THE BIRTH DATE WITH A DEATH OF OCTOBER 1389?
SQL: SELECT "birth" FROM prince_of_girona WHERE "death" = 'october 1389'