When David McNamara was the opponent in the final, what was the tier?
CREATE TABLE table_name_59 (
    tier VARCHAR,
    opponent_in_the_final VARCHAR
)
SELECT tier FROM table_name_59 WHERE opponent_in_the_final = "david mcnamara"
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: When David McNamara was the opponent in the final, what was the tier? ### Input: CREATE TABLE table_name_59 (
    tier VARCHAR,
    opponent_in_the_final VARCHAR
) ### Response: SELECT tier FROM table_name_59 WHERE opponent_in_the_final = "david mcnamara"