mikael pernfors
the first time mikael pernfors played in the finals on a hard surface , his opponent was andre agassi .
{'scope': 'subset', 'col_superlative': '2', 'row_superlative': '2', 'value_mentioned': 'no', 'max_or_min': 'min', 'other_col': '4,5', 'subset': {'col': '4', 'criterion': 'fuzzily_match', 'value': 'hard'}}
{'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'argmin', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'surface', 'hard'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; surface ; hard }', 'tointer': 'select the rows whose surface record fuzzily matches to hard .'}, 'date'], 'result': None, 'ind': 1, 'tostr': 'argmin { filter_eq { all_rows ; surface ; hard } ; date }'}, 'opponent in the final'], 'result': 'andre agassi', 'ind': 2, 'tostr': 'hop { argmin { filter_eq { all_rows ; surface ; hard } ; date } ; opponent in the final }'}, 'andre agassi'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { argmin { filter_eq { all_rows ; surface ; hard } ; date } ; opponent in the final } ; andre agassi } = true', 'tointer': 'select the rows whose surface record fuzzily matches to hard . select the row whose date record of these rows is minimum . the opponent in the final record of this row is andre agassi .'}
eq { hop { argmin { filter_eq { all_rows ; surface ; hard } ; date } ; opponent in the final } ; andre agassi } = true
select the rows whose surface record fuzzily matches to hard . select the row whose date record of these rows is minimum . the opponent in the final record of this row is andre agassi .
{'str_eq_3': 'str_eq', 'result_4': 'true', 'str_hop_2': 'str_hop', 'argmin_1': 'argmin', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_5': 'all_rows', 'surface_6': 'surface', 'hard_7': 'hard', 'date_8': 'date', 'opponent in the final_9': 'opponent in the final', 'andre agassi_10': 'andre agassi'}
['outcome', 'date', 'championship', 'surface', 'opponent in the final', 'score in the final']
[['runner - up', '26 may 1986', 'french open , paris , france', 'clay', 'ivan lendl', '3 - 6 , 2 - 6 , 4 - 6'], ['runner - up', '15 february 1988', 'memphis , usa', 'hard ( i )', 'andre agassi', '4 - 6 , 4 - 6 , 5 - 7'], ['winner', '19 september 1988', 'los angeles , usa', 'hard', 'andre agassi', '6 - 2 , 7 - 5'], ['winner', '3 october 1988', 'scottsdale , usa', 'hard', 'glenn layendecker', '6 - 2 , 6 - 4'], ['winner', '28 february 1993', 'montreal , canada', 'hard', 'todd martin', '2 - 6 , 6 - 2 , 7 - 5']]