Table: tennis_matches_40
Columns: outcome
date
championship
surface
opponent_in_the_final
score_in_the_final

Question: What is Surface, when Date is less than 1979, and when Opponent in the Final is "Bill Scanlon"?
SQL: SELECT "surface" FROM tennis_matches_40 WHERE "date" < 1979 AND "opponent_in_the_final" = 'bill scanlon'

Question: What is Score in The Final, when Opponent in The Final is "John McEnroe", and when Championship is "Los Angeles , U.S."?
SQL: SELECT "score_in_the_final" FROM tennis_matches_40 WHERE "opponent_in_the_final" = 'john mcenroe' AND "championship" = 'los angeles , u.s.'

Question: What is Outcome, when Opponent in The Final is "Bill Scanlon"?
SQL: SELECT "outcome" FROM tennis_matches_40 WHERE "opponent_in_the_final" = 'bill scanlon'