2007 - 08 segunda división
in the 2007-08 segunda division , bernardo had a better average than juan pablo .
{'row_1': '8', 'row_2': '9', 'col': '4', 'col_other': '1', 'relation': 'less', 'record_mentioned': 'no', 'diff_result': None}
{'func': 'less', 'args': [{'func': 'num_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'goalkeeper', 'bernardo'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose goalkeeper record fuzzily matches to bernardo .', 'tostr': 'filter_eq { all_rows ; goalkeeper ; bernardo }'}, 'average'], 'result': None, 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; goalkeeper ; bernardo } ; average }', 'tointer': 'select the rows whose goalkeeper record fuzzily matches to bernardo . take the average record of this row .'}, {'func': 'num_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'goalkeeper', 'javier varas'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose goalkeeper record fuzzily matches to javier varas .', 'tostr': 'filter_eq { all_rows ; goalkeeper ; javier varas }'}, 'average'], 'result': None, 'ind': 3, 'tostr': 'hop { filter_eq { all_rows ; goalkeeper ; javier varas } ; average }', 'tointer': 'select the rows whose goalkeeper record fuzzily matches to javier varas . take the average record of this row .'}], 'result': True, 'ind': 4, 'tostr': 'less { hop { filter_eq { all_rows ; goalkeeper ; bernardo } ; average } ; hop { filter_eq { all_rows ; goalkeeper ; javier varas } ; average } } = true', 'tointer': 'select the rows whose goalkeeper record fuzzily matches to bernardo . take the average record of this row . select the rows whose goalkeeper record fuzzily matches to javier varas . take the average record of this row . the first record is less than the second record .'}
less { hop { filter_eq { all_rows ; goalkeeper ; bernardo } ; average } ; hop { filter_eq { all_rows ; goalkeeper ; javier varas } ; average } } = true
select the rows whose goalkeeper record fuzzily matches to bernardo . take the average record of this row . select the rows whose goalkeeper record fuzzily matches to javier varas . take the average record of this row . the first record is less than the second record .
{'less_4': 'less', 'result_5': 'true', 'num_hop_2': 'num_hop', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'goalkeeper_7': 'goalkeeper', 'bernardo_8': 'bernardo', 'average_9': 'average', 'num_hop_3': 'num_hop', 'filter_str_eq_1': 'filter_str_eq', 'all_rows_10': 'all_rows', 'goalkeeper_11': 'goalkeeper', 'javier varas_12': 'javier varas', 'average_13': 'average'}
['goalkeeper', 'goals', 'matches', 'average', 'team']
[['carlos sánchez', '27', '33', '0.82', 'cd castellón'], ['jacobo', '29', '32', '0.91', 'cd numancia'], ['asier riesgo', '39', '42', '0.93', 'real sociedad'], ['roberto', '39', '41', '0.95', 'sporting de gijón'], ['iñaki goitia', '41', '40', '1.02', 'málaga cf'], ['pedro contreras', '37', '36', '1.03', 'cádiz cf'], ['wilfredo caballero', '41', '38', '1.08', 'elche cf'], ['bernardo', '42', '38', '1.11', 'deportivo alavés'], ['javier varas', '46', '41', '1.12', 'sevilla atlético'], ['juan pablo', '33', '29', '1.14', 'cd tenerife']]