Name the championship for peter mcnamara
CREATE TABLE table_22597626_6 (championship VARCHAR, opponent_in_the_final VARCHAR)
SELECT championship FROM table_22597626_6 WHERE opponent_in_the_final = "Peter McNamara"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_22597626_6 (championship VARCHAR, opponent_in_the_final VARCHAR) Question: Name the championship for peter mcnamara [/INST] SELECT championship FROM table_22597626_6 WHERE opponent_in_the_final = "Peter McNamara" </s>