CREATE TABLE table_23235767_1 (score_in_the_final VARCHAR2, opponent_in_the_final VARCHAR2, championship VARCHAR2)

What is every score in the final for opponent in final John Mcenroe at US Open?
SELECT score_in_the_final FROM table_23235767_1 WHERE opponent_in_the_final = "John McEnroe" AND championship = "US Open"
SELECT "score_in_the_final" FROM "table_23235767_1" WHERE "John McEnroe" = "opponent_in_the_final" AND "US Open" = "championship"