CREATE TABLE table_name_55 (contract_length VARCHAR2, status VARCHAR2)

What is the contract length when rejected is the status?
SELECT contract_length FROM table_name_55 WHERE status = "rejected"
SELECT "contract_length" FROM "table_name_55" WHERE "rejected" = "status"