baie - comeau drakkar
the 1997-1998 season was the only one where baie - comeau drakkar had more than 300 goals against .
{'scope': 'all', 'row': '1', 'col': '6', 'col_other': '1', 'criterion': 'greater_than', 'value': '300', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'goalsagainst', '300'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose goalsagainst record is greater than 300 .', 'tostr': 'filter_greater { all_rows ; goalsagainst ; 300 }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_greater { all_rows ; goalsagainst ; 300 } }', 'tointer': 'select the rows whose goalsagainst record is greater than 300 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'goalsagainst', '300'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose goalsagainst record is greater than 300 .', 'tostr': 'filter_greater { all_rows ; goalsagainst ; 300 }'}, 'season'], 'result': '1997 - 98', 'ind': 2, 'tostr': 'hop { filter_greater { all_rows ; goalsagainst ; 300 } ; season }'}, '1997 - 98'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_greater { all_rows ; goalsagainst ; 300 } ; season } ; 1997 - 98 }', 'tointer': 'the season record of this unqiue row is 1997 - 98 .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_greater { all_rows ; goalsagainst ; 300 } } ; eq { hop { filter_greater { all_rows ; goalsagainst ; 300 } ; season } ; 1997 - 98 } } = true', 'tointer': 'select the rows whose goalsagainst record is greater than 300 . there is only one such row in the table . the season record of this unqiue row is 1997 - 98 .'}
and { only { filter_greater { all_rows ; goalsagainst ; 300 } } ; eq { hop { filter_greater { all_rows ; goalsagainst ; 300 } ; season } ; 1997 - 98 } } = true
select the rows whose goalsagainst record is greater than 300 . there is only one such row in the table . the season record of this unqiue row is 1997 - 98 .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_greater_0': 'filter_greater', 'all_rows_6': 'all_rows', 'goalsagainst_7': 'goalsagainst', '300_8': '300', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'season_9': 'season', '1997 - 98_10': '1997 - 98'}
['season', 'games', 'lost', 'points', 'goalsfor', 'goalsagainst']
[['1997 - 98', '70', '47', '41', '215', '332'], ['1998 - 99', '70', '44', '44', '208', '297'], ['1999 - 2000', '72', '31', '72', '257', '285'], ['2000 - 01', '72', '23', '90', '283', '255'], ['2001 - 02', '72', '25', '85', '288', '231'], ['2002 - 03', '72', '14', '108', '319', '213'], ['2003 - 04', '70', '42', '49', '195', '285'], ['2004 - 05', '70', '37', '57', '208', '280'], ['2005 - 06', '70', '38', '62', '249', '285'], ['2006 - 07', '70', '26', '79', '304', '285'], ['2007 - 08', '70', '19', '96', '249', '210'], ['2008 - 09', '68', '37', '53', '206', '297'], ['2009 - 10', '68', '40', '49', '187', '297'], ['2010 - 11', '68', '46', '34', '151', '266'], ['2011 - 12', '68', '34', '63', '217', '241']]