2007 gran premio tecate
at the 2007 gran premio tecate the only driver to complete 64 laps and score more than 30 points was sébastien bourdais .
{'scope': 'subset', 'row': '1', 'col': '6', 'col_other': '1', 'criterion': 'greater_than', 'value': '30', 'subset': {'col': '3', 'criterion': 'equal', 'value': '64'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_greater', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'laps', '64'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; laps ; 64 }', 'tointer': 'select the rows whose laps record is equal to 64 .'}, 'points', '30'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose laps record is equal to 64 . among these rows , select the rows whose points record is greater than 30 .', 'tostr': 'filter_greater { filter_eq { all_rows ; laps ; 64 } ; points ; 30 }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_greater { filter_eq { all_rows ; laps ; 64 } ; points ; 30 } }', 'tointer': 'select the rows whose laps record is equal to 64 . among these rows , select the rows whose points record is greater than 30 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_greater', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'laps', '64'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; laps ; 64 }', 'tointer': 'select the rows whose laps record is equal to 64 .'}, 'points', '30'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose laps record is equal to 64 . among these rows , select the rows whose points record is greater than 30 .', 'tostr': 'filter_greater { filter_eq { all_rows ; laps ; 64 } ; points ; 30 }'}, 'driver'], 'result': 'sébastien bourdais', 'ind': 3, 'tostr': 'hop { filter_greater { filter_eq { all_rows ; laps ; 64 } ; points ; 30 } ; driver }'}, 'sébastien bourdais'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_greater { filter_eq { all_rows ; laps ; 64 } ; points ; 30 } ; driver } ; sébastien bourdais }', 'tointer': 'the driver record of this unqiue row is sébastien bourdais .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_greater { filter_eq { all_rows ; laps ; 64 } ; points ; 30 } } ; eq { hop { filter_greater { filter_eq { all_rows ; laps ; 64 } ; points ; 30 } ; driver } ; sébastien bourdais } } = true', 'tointer': 'select the rows whose laps record is equal to 64 . among these rows , select the rows whose points record is greater than 30 . there is only one such row in the table . the driver record of this unqiue row is sébastien bourdais .'}
and { only { filter_greater { filter_eq { all_rows ; laps ; 64 } ; points ; 30 } } ; eq { hop { filter_greater { filter_eq { all_rows ; laps ; 64 } ; points ; 30 } ; driver } ; sébastien bourdais } } = true
select the rows whose laps record is equal to 64 . among these rows , select the rows whose points record is greater than 30 . there is only one such row in the table . the driver record of this unqiue row is sébastien bourdais .
{'and_5': 'and', 'result_6': 'true', 'only_2': 'only', 'filter_greater_1': 'filter_greater', 'filter_eq_0': 'filter_eq', 'all_rows_7': 'all_rows', 'laps_8': 'laps', '64_9': '64', 'points_10': 'points', '30_11': '30', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'driver_12': 'driver', 'sébastien bourdais_13': 'sébastien bourdais'}
['driver', 'team', 'laps', 'time / retired', 'grid', 'points']
[['sébastien bourdais', 'n / h / l racing', '64', '1:45:02.885', '2', '32'], ['will power', 'team australia', '64', '+ 1.906', '1', '29'], ['oriol servià', 'pkv racing', '64', '+ 3.364', '4', '25'], ['graham rahal', 'n / h / l racing', '64', '+ 7.346', '7', '23'], ['paul tracy', 'forsythe racing', '64', '+ 8.593', '8', '21'], ['simon pagenaud', 'team australia', '64', '+ 9.638', '6', '19'], ['bruno junqueira', 'dale coyne racing', '64', '+ 15.823', '12', '17'], ['mario domínguez', 'pacific coast motorsports', '64', '+ 16.077', '15', '16'], ['neel jani', 'pkv racing', '64', '+ 16.199', '11', '13'], ['justin wilson', 'rusport', '64', '+ 16.954', '5', '11'], ['alex figge', 'pacific coast motorsports', '63', '+ 1 lap', '17', '10'], ['nelson philippe', 'conquest racing', '63', '+ 1 lap', '13', '9'], ['alex tagliani', 'rocketsports racing', '62', '+ 2 laps', '14', '8'], ['david martínez', 'forsythe racing', '58', '+ 6 laps', '10', '7'], ['katherine legge', 'dale coyne racing', '56', 'mechanical', '16', '6'], ['robert doornbos', 'minardi team usa', '12', 'mechanical', '3', '6'], ['dan clarke', 'minardi team usa', '0', 'mechanical', '9', '4']]