opec
in opec the most recent country to join the middle east was the united arab emirates in 1967 .
{'scope': 'subset', 'col_superlative': '3', 'row_superlative': '9', 'value_mentioned': 'yes', 'max_or_min': 'max', 'other_col': '1,2', 'subset': {'col': '2', 'criterion': 'equal', 'value': 'middle east'}}
{'func': 'and', 'args': [{'func': 'eq', 'args': [{'func': 'max', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'region', 'middle east'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; region ; middle east }', 'tointer': 'select the rows whose region record fuzzily matches to middle east .'}, 'joined opec'], 'result': '1967', 'ind': 1, 'tostr': 'max { filter_eq { all_rows ; region ; middle east } ; joined opec }', 'tointer': 'select the rows whose region record fuzzily matches to middle east . the maximum joined opec record of these rows is 1967 .'}, '1967'], 'result': True, 'ind': 2, 'tostr': 'eq { max { filter_eq { all_rows ; region ; middle east } ; joined opec } ; 1967 }', 'tointer': 'select the rows whose region record fuzzily matches to middle east . the maximum joined opec record of these rows is 1967 .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'argmax', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'region', 'middle east'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; region ; middle east }', 'tointer': 'select the rows whose region record fuzzily matches to middle east .'}, 'joined opec'], 'result': None, 'ind': 3, 'tostr': 'argmax { filter_eq { all_rows ; region ; middle east } ; joined opec }'}, 'country'], 'result': 'united arab emirates', 'ind': 4, 'tostr': 'hop { argmax { filter_eq { all_rows ; region ; middle east } ; joined opec } ; country }'}, 'united arab emirates'], 'result': True, 'ind': 5, 'tostr': 'eq { hop { argmax { filter_eq { all_rows ; region ; middle east } ; joined opec } ; country } ; united arab emirates }', 'tointer': 'the country record of the row with superlative joined opec record is united arab emirates .'}], 'result': True, 'ind': 6, 'tostr': 'and { eq { max { filter_eq { all_rows ; region ; middle east } ; joined opec } ; 1967 } ; eq { hop { argmax { filter_eq { all_rows ; region ; middle east } ; joined opec } ; country } ; united arab emirates } } = true', 'tointer': 'select the rows whose region record fuzzily matches to middle east . the maximum joined opec record of these rows is 1967 . the country record of the row with superlative joined opec record is united arab emirates .'}
and { eq { max { filter_eq { all_rows ; region ; middle east } ; joined opec } ; 1967 } ; eq { hop { argmax { filter_eq { all_rows ; region ; middle east } ; joined opec } ; country } ; united arab emirates } } = true
select the rows whose region record fuzzily matches to middle east . the maximum joined opec record of these rows is 1967 . the country record of the row with superlative joined opec record is united arab emirates .
{'and_6': 'and', 'result_7': 'true', 'eq_2': 'eq', 'max_1': 'max', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_8': 'all_rows', 'region_9': 'region', 'middle east_10': 'middle east', 'joined opec_11': 'joined opec', '1967_12': '1967', 'str_eq_5': 'str_eq', 'str_hop_4': 'str_hop', 'argmax_3': 'argmax', 'joined opec_13': 'joined opec', 'country_14': 'country', 'united arab emirates_15': 'united arab emirates'}
['country', 'region', 'joined opec', 'population ( july 2012 )', 'area ( km square )', 'production ( bbl / day )']
[['algeria', 'africa', '1969', '37367226', '2381740', '2125000 ( 16th )'], ['angola', 'africa', '2007', '18056072', '1246700', '1948000 ( 17th )'], ['iraq', 'middle east', '1960', '31129225', '437072', '3200000 ( 12th )'], ['kuwait', 'middle east', '1960', '2646314', '17820', '2494000 ( 10th )'], ['libya', 'africa', '1962', '5613380', '1759540', '2210000 ( 15th )'], ['nigeria', 'africa', '1971', '170123740', '923768', '2211000 ( 14th )'], ['qatar', 'middle east', '1961', '1951591', '11437', '1213000 ( 21st )'], ['saudi arabia', 'middle east', '1960', '26534504', '2149690', '8800000 ( 1st )'], ['united arab emirates', 'middle east', '1967', '5314317', '83600', '2798000 ( 8th )'], ['venezuela', 'south america', '1960', '28047938', '912050', '2472000 ( 11th )']]