user: ### NOW ANSWER:
Question: What is Score in The Final, when Opponent in The Final is "John McEnroe", and when Championship is "Los Angeles , U.S."?
Columns: ['Outcome', 'Date', 'Championship', 'Surface', 'Opponent in the final', 'Score in the final']
Types: ['text', 'real', 'text', 'text', 'text', 'text']
Sample row: ['Runner-up', 1978.0, 'Maui , U.S.', 'Hard', 'Bill Scanlon', '2–6, 0–6']
SQL:

assistant: SELECT "Score in the final" FROM "Table" WHERE "Opponent in the final" = 'John McEnroe' AND "Championship" = 'Los Angeles , U.S.';