opec
for opec , for the countries in the africa region , the only one who joined opec in 1969 is algeria .
{'scope': 'subset', 'row': '1', 'col': '3', 'col_other': '1', 'criterion': 'equal', 'value': '1969', 'subset': {'col': '2', 'criterion': 'equal', 'value': 'africa'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'region', 'africa'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; region ; africa }', 'tointer': 'select the rows whose region record fuzzily matches to africa .'}, 'joined opec', '1969'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose region record fuzzily matches to africa . among these rows , select the rows whose joined opec record is equal to 1969 .', 'tostr': 'filter_eq { filter_eq { all_rows ; region ; africa } ; joined opec ; 1969 }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_eq { filter_eq { all_rows ; region ; africa } ; joined opec ; 1969 } }', 'tointer': 'select the rows whose region record fuzzily matches to africa . among these rows , select the rows whose joined opec record is equal to 1969 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'region', 'africa'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; region ; africa }', 'tointer': 'select the rows whose region record fuzzily matches to africa .'}, 'joined opec', '1969'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose region record fuzzily matches to africa . among these rows , select the rows whose joined opec record is equal to 1969 .', 'tostr': 'filter_eq { filter_eq { all_rows ; region ; africa } ; joined opec ; 1969 }'}, 'country'], 'result': 'algeria', 'ind': 3, 'tostr': 'hop { filter_eq { filter_eq { all_rows ; region ; africa } ; joined opec ; 1969 } ; country }'}, 'algeria'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_eq { filter_eq { all_rows ; region ; africa } ; joined opec ; 1969 } ; country } ; algeria }', 'tointer': 'the country record of this unqiue row is algeria .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_eq { filter_eq { all_rows ; region ; africa } ; joined opec ; 1969 } } ; eq { hop { filter_eq { filter_eq { all_rows ; region ; africa } ; joined opec ; 1969 } ; country } ; algeria } } = true', 'tointer': 'select the rows whose region record fuzzily matches to africa . among these rows , select the rows whose joined opec record is equal to 1969 . there is only one such row in the table . the country record of this unqiue row is algeria .'}
and { only { filter_eq { filter_eq { all_rows ; region ; africa } ; joined opec ; 1969 } } ; eq { hop { filter_eq { filter_eq { all_rows ; region ; africa } ; joined opec ; 1969 } ; country } ; algeria } } = true
select the rows whose region record fuzzily matches to africa . among these rows , select the rows whose joined opec record is equal to 1969 . there is only one such row in the table . the country record of this unqiue row is algeria .
{'and_5': 'and', 'result_6': 'true', 'only_2': 'only', 'filter_eq_1': 'filter_eq', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_7': 'all_rows', 'region_8': 'region', 'africa_9': 'africa', 'joined opec_10': 'joined opec', '1969_11': '1969', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'country_12': 'country', 'algeria_13': 'algeria'}
['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 )']]