Table schema:
CREATE TABLE table_name_47 (birth VARCHAR, ceased_to_be_queen VARCHAR)

Question: What is the birth date of the woman who ceased to be Queen on 18 Jun 1297?
SQL: SELECT birth FROM table_name_47 WHERE ceased_to_be_queen = "18 jun 1297"