2012 in film
wreck - it ralph had a lower wordwide gross than the twilight saga : breaking dawn - part 2 .
{'row_1': '14', 'row_2': '6', 'col': '5', 'col_other': '2', 'relation': 'less', 'record_mentioned': 'no', 'diff_result': None}
{'func': 'less', 'args': [{'func': 'num_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'title', 'wreck - it ralph'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose title record fuzzily matches to wreck - it ralph .', 'tostr': 'filter_eq { all_rows ; title ; wreck - it ralph }'}, 'worldwide gross'], 'result': None, 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; title ; wreck - it ralph } ; worldwide gross }', 'tointer': 'select the rows whose title record fuzzily matches to wreck - it ralph . take the worldwide gross record of this row .'}, {'func': 'num_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'title', 'the twilight saga : breaking dawn - part 2'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose title record fuzzily matches to the twilight saga : breaking dawn - part 2 .', 'tostr': 'filter_eq { all_rows ; title ; the twilight saga : breaking dawn - part 2 }'}, 'worldwide gross'], 'result': None, 'ind': 3, 'tostr': 'hop { filter_eq { all_rows ; title ; the twilight saga : breaking dawn - part 2 } ; worldwide gross }', 'tointer': 'select the rows whose title record fuzzily matches to the twilight saga : breaking dawn - part 2 . take the worldwide gross record of this row .'}], 'result': True, 'ind': 4, 'tostr': 'less { hop { filter_eq { all_rows ; title ; wreck - it ralph } ; worldwide gross } ; hop { filter_eq { all_rows ; title ; the twilight saga : breaking dawn - part 2 } ; worldwide gross } } = true', 'tointer': 'select the rows whose title record fuzzily matches to wreck - it ralph . take the worldwide gross record of this row . select the rows whose title record fuzzily matches to the twilight saga : breaking dawn - part 2 . take the worldwide gross record of this row . the first record is less than the second record .'}
less { hop { filter_eq { all_rows ; title ; wreck - it ralph } ; worldwide gross } ; hop { filter_eq { all_rows ; title ; the twilight saga : breaking dawn - part 2 } ; worldwide gross } } = true
select the rows whose title record fuzzily matches to wreck - it ralph . take the worldwide gross record of this row . select the rows whose title record fuzzily matches to the twilight saga : breaking dawn - part 2 . take the worldwide gross record of this row . the first record is less than the second record .
{'less_4': 'less', 'result_5': 'true', 'num_hop_2': 'num_hop', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'title_7': 'title', 'wreck - it ralph_8': 'wreck - it ralph', 'worldwide gross_9': 'worldwide gross', 'num_hop_3': 'num_hop', 'filter_str_eq_1': 'filter_str_eq', 'all_rows_10': 'all_rows', 'title_11': 'title', 'the twilight saga : breaking dawn - part 2_12': 'the twilight saga : breaking dawn - part 2', 'worldwide gross_13': 'worldwide gross'}
['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']]