drop tower : scream zone
only one drop tower can achieve a speed higher than 70 mph .
{'scope': 'all', 'row': '4', 'col': '4', 'col_other': '5', 'criterion': 'greater_than', 'value': '70 mph', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'speed', '70 mph'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose speed record is greater than 70 mph .', 'tostr': 'filter_greater { all_rows ; speed ; 70 mph }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_greater { all_rows ; speed ; 70 mph } }', 'tointer': 'select the rows whose speed record is greater than 70 mph . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'speed', '70 mph'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose speed record is greater than 70 mph .', 'tostr': 'filter_greater { all_rows ; speed ; 70 mph }'}, 'model'], 'result': 'gyro drop', 'ind': 2, 'tostr': 'hop { filter_greater { all_rows ; speed ; 70 mph } ; model }'}, 'gyro drop'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_greater { all_rows ; speed ; 70 mph } ; model } ; gyro drop }', 'tointer': 'the model record of this unqiue row is gyro drop .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_greater { all_rows ; speed ; 70 mph } } ; eq { hop { filter_greater { all_rows ; speed ; 70 mph } ; model } ; gyro drop } } = true', 'tointer': 'select the rows whose speed record is greater than 70 mph . there is only one such row in the table . the model record of this unqiue row is gyro drop .'}
and { only { filter_greater { all_rows ; speed ; 70 mph } } ; eq { hop { filter_greater { all_rows ; speed ; 70 mph } ; model } ; gyro drop } } = true
select the rows whose speed record is greater than 70 mph . there is only one such row in the table . the model record of this unqiue row is gyro drop .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_greater_0': 'filter_greater', 'all_rows_6': 'all_rows', 'speed_7': 'speed', '70 mph_8': '70 mph', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'model_9': 'model', 'gyro drop_10': 'gyro drop'}
['park', 'tower height', 'drop height', 'speed', 'model', 'opened', 'height requirement']
[["canada 's wonderland", '230feet', '200feet', '62 mph', 'giant drop', '1997', 'inches ( cm )'], ['carowinds', '174feet', '100feet', '56 mph', 'giant drop', 'march 1996', 'inches ( cm )'], ["california 's great america", '224feet', '207feet', '62 mph', 'giant drop', 'march 1996', 'inches ( cm )'], ['kings dominion', '305feet', '272feet', '72 mph', 'gyro drop', 'march 22 , 2003', 'inches ( cm )'], ['kings island', '315feet', '264feet', '67 mph', 'gyro drop', '1999', 'inches ( cm )']]