2012 in film
the hunger games is the only 2012 that was directed by gary ross .
{'scope': 'all', 'row': '9', 'col': '4', 'col_other': '2', 'criterion': 'equal', 'value': 'gary ross', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'director ( s )', 'gary ross'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose director ( s ) record fuzzily matches to gary ross .', 'tostr': 'filter_eq { all_rows ; director ( s ) ; gary ross }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; director ( s ) ; gary ross } }', 'tointer': 'select the rows whose director ( s ) record fuzzily matches to gary ross . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'director ( s )', 'gary ross'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose director ( s ) record fuzzily matches to gary ross .', 'tostr': 'filter_eq { all_rows ; director ( s ) ; gary ross }'}, 'title'], 'result': 'the hunger games', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; director ( s ) ; gary ross } ; title }'}, 'the hunger games'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; director ( s ) ; gary ross } ; title } ; the hunger games }', 'tointer': 'the title record of this unqiue row is the hunger games .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; director ( s ) ; gary ross } } ; eq { hop { filter_eq { all_rows ; director ( s ) ; gary ross } ; title } ; the hunger games } } = true', 'tointer': 'select the rows whose director ( s ) record fuzzily matches to gary ross . there is only one such row in the table . the title record of this unqiue row is the hunger games .'}
and { only { filter_eq { all_rows ; director ( s ) ; gary ross } } ; eq { hop { filter_eq { all_rows ; director ( s ) ; gary ross } ; title } ; the hunger games } } = true
select the rows whose director ( s ) record fuzzily matches to gary ross . there is only one such row in the table . the title record of this unqiue row is the hunger games .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'director (s)_7': 'director ( s )', 'gary ross_8': 'gary ross', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'title_9': 'title', 'the hunger games_10': 'the hunger games'}
['rank', 'title', 'studio', 'director ( s )', 'worldwide gross']
[['1', 'the avengers', 'marvel / disney', 'joss whedon', '1511757910'], ['2', 'skyfall', 'mgm / columbia pictures', 'sam mendes', '1108561013'], ['3', 'the dark knight rises', 'warner bros / legendary pictures', 'christopher nolan', '1084439099'], ['4', 'the hobbit : an unexpected journey', 'warner bros / mgm / new line', 'peter jackson', '1017003568'], ['5', 'ice age : continental drift', '20th century fox / blue sky', 'steve martino and mike thurmeier', '877244782'], ['6', 'the twilight saga : breaking dawn - part 2', 'lionsgate / summit', 'bill condon', '829224737'], ['7', 'the amazing spider - man', 'columbia pictures', 'marc webb', '752216557'], ['8', "madagascar 3 : europe 's most wanted", 'paramount / dreamworks', 'eric darnell , tom mcgrath and conrad vernon', '746921274'], ['9', 'the hunger games', 'lionsgate', 'gary ross', '691247768'], ['10', 'men in black 3', 'columbia pictures', 'barry sonnenfeld', '624026776'], ['11', 'life of pi', '20th century fox', 'ang lee', '609016565'], ['12', 'ted', 'universal pictures', 'seth macfarlane', '549368315'], ['13', 'brave', 'walt disney pictures / pixar animation studios', 'mark andrews and brenda chapman', '538983207'], ['14', 'wreck - it ralph', 'walt disney pictures', 'rich moore', '471222889'], ['15', 'les misérables', 'universal pictures', 'tom hooper', '441809770'], ['16', 'the intouchables', 'gaumont film company', 'olivier nakache and éric toledano', '426588510'], ['17', 'django unchained', 'the weinstein company / columbia pictures', 'quentin tarantino', '425368238'], ['18', 'prometheus', '20th century fox', 'ridley scott', '403354469'], ['19', 'snow white and the huntsman', 'universal pictures', 'rupert sanders', '396592829'], ['20', 'taken 2', '20th century fox', 'olivier megaton', '376141306']]