1985 in film
the fifth highest grossing movie in 1985 was " the color purple " , directed by spike lee .
{'scope': 'all', 'row': '5', 'col': '5', 'order': '5', 'col_other': '2,4', 'max_or_min': 'max_to_min', 'value_mentioned': 'no', 'subset': None}
{'func': 'and', 'args': [{'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'nth_argmax', 'args': ['all_rows', 'gross', '5'], 'result': None, 'ind': 0, 'tostr': 'nth_argmax { all_rows ; gross ; 5 }'}, 'title'], 'result': 'the color purple', 'ind': 1, 'tostr': 'hop { nth_argmax { all_rows ; gross ; 5 } ; title }'}, 'the color purple'], 'result': True, 'ind': 2, 'tostr': 'eq { hop { nth_argmax { all_rows ; gross ; 5 } ; title } ; the color purple }', 'tointer': 'select the row whose gross record of all rows is 5th maximum . the title record of this row is the color purple .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'nth_argmax', 'args': ['all_rows', 'gross', '5'], 'result': None, 'ind': 0, 'tostr': 'nth_argmax { all_rows ; gross ; 5 }'}, 'director'], 'result': 'steven spielberg', 'ind': 3, 'tostr': 'hop { nth_argmax { all_rows ; gross ; 5 } ; director }'}, 'steven spielberg'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { nth_argmax { all_rows ; gross ; 5 } ; director } ; steven spielberg }', 'tointer': 'the director record of this row is steven spielberg .'}], 'result': True, 'ind': 5, 'tostr': 'and { eq { hop { nth_argmax { all_rows ; gross ; 5 } ; title } ; the color purple } ; eq { hop { nth_argmax { all_rows ; gross ; 5 } ; director } ; steven spielberg } } = true', 'tointer': 'select the row whose gross record of all rows is 5th maximum . the title record of this row is the color purple . the director record of this row is steven spielberg .'}
and { eq { hop { nth_argmax { all_rows ; gross ; 5 } ; title } ; the color purple } ; eq { hop { nth_argmax { all_rows ; gross ; 5 } ; director } ; steven spielberg } } = true
select the row whose gross record of all rows is 5th maximum . the title record of this row is the color purple . the director record of this row is steven spielberg .
{'and_5': 'and', 'result_6': 'true', 'str_eq_2': 'str_eq', 'str_hop_1': 'str_hop', 'nth_argmax_0': 'nth_argmax', 'all_rows_7': 'all_rows', 'gross_8': 'gross', '5_9': '5', 'title_10': 'title', 'the color purple_11': 'the color purple', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'director_12': 'director', 'steven spielberg_13': 'steven spielberg'}
['rank', 'title', 'studio', 'director', 'gross']
[['1', 'back to the future', 'universal', 'robert zemeckis', '215000000'], ['2', 'rocky iv', 'united artists', 'sylvester stallone', '127873716'], ['3', 'rambo : first blood part ii', 'tri - star / carolco', 'george pan cosmatos', '150415432'], ['4', 'out of africa', 'universal', 'sydney pollack', '128499205'], ['5', 'the color purple', 'warner bros', 'steven spielberg', '98467863'], ['6', 'the jewel of the nile', '20th century fox', 'lewis teague', '96773200'], ['7', 'cocoon', '20th century fox', 'ron howard', '85313124'], ['8', 'witness', 'paramount', 'peter weir', '68706993'], ['9', 'police academy 2 : their first assignment', 'warner bros / ladd', 'jerry paris', '61600000'], ['10', 'the goonies', 'warner bros', 'richard donner', '61389680'], ['11', 'spies like us', 'warner bros', 'john landis', '60088980'], ['12', 'a view to a kill', 'united artists', 'john glen', '50300000'], ['13', 'fletch', 'universal', 'michael ritchie', '50600000'], ['14', "national lampoon 's european vacation", 'warner bros', 'amy heckerling', '49364621'], ['15', 'mask', 'universal', 'peter bogdanovich', '48230162'], ['16', "brewster 's millions", 'universal', 'walter hill', '45833132'], ['17', 'the breakfast club', 'universal', 'john hughes', '45000000'], ['18', 'white nights', 'columbia', 'taylor hackford', '42160849'], ['19', 'pale rider', 'warner bros', 'clint eastwood', '41410568'], ['20', "pee - wee 's big adventure", 'warner bros', 'tim burton', '40940662']]