Table: tennis_player_stats
Columns: outcome
date
championship
surface
opponent_in_the_final
score_in_the_final

Question: What was the Outcome against Opponent in the Final Carlos Kirmayr?
SQL: SELECT "outcome" FROM tennis_player_stats WHERE "opponent_in_the_final" = 'carlos kirmayr'

Question: What was the Score in the Final against Opponent in the Final Manuel Orantes, prior to 1978?
SQL: SELECT "score_in_the_final" FROM tennis_player_stats WHERE "date" < 1978 AND "opponent_in_the_final" = 'manuel orantes'

Question: Against Opponent in the Final Ivan Lendl, on a Surface of clay, with an Outcome of runner-up, where was the Championship?
SQL: SELECT "championship" FROM tennis_player_stats WHERE "outcome" = 'runner-up' AND "surface" = 'clay' AND "opponent_in_the_final" = 'ivan lendl'

Question: What is the earliest Date on a Surface of clay in a Championship in Linz, Austria?
SQL: SELECT MIN("date") FROM tennis_player_stats WHERE "surface" = 'clay' AND "championship" = 'linz, austria'