sandra roma
among the itf finals that sandra roma won , 4 of them were on clay surface .
{'scope': 'subset', 'criterion': 'equal', 'value': 'clay', 'result': '4', 'col': '4', 'subset': {'col': '1', 'criterion': 'equal', 'value': 'winner'}}
{'func': 'eq', 'args': [{'func': 'count', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'outcome', 'winner'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; outcome ; winner }', 'tointer': 'select the rows whose outcome record fuzzily matches to winner .'}, 'surface', 'clay'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose outcome record fuzzily matches to winner . among these rows , select the rows whose surface record fuzzily matches to clay .', 'tostr': 'filter_eq { filter_eq { all_rows ; outcome ; winner } ; surface ; clay }'}], 'result': '4', 'ind': 2, 'tostr': 'count { filter_eq { filter_eq { all_rows ; outcome ; winner } ; surface ; clay } }', 'tointer': 'select the rows whose outcome record fuzzily matches to winner . among these rows , select the rows whose surface record fuzzily matches to clay . the number of such rows is 4 .'}, '4'], 'result': True, 'ind': 3, 'tostr': 'eq { count { filter_eq { filter_eq { all_rows ; outcome ; winner } ; surface ; clay } } ; 4 } = true', 'tointer': 'select the rows whose outcome record fuzzily matches to winner . among these rows , select the rows whose surface record fuzzily matches to clay . the number of such rows is 4 .'}
eq { count { filter_eq { filter_eq { all_rows ; outcome ; winner } ; surface ; clay } } ; 4 } = true
select the rows whose outcome record fuzzily matches to winner . among these rows , select the rows whose surface record fuzzily matches to clay . the number of such rows is 4 .
{'eq_3': 'eq', 'result_4': 'true', 'count_2': 'count', 'filter_str_eq_1': 'filter_str_eq', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_5': 'all_rows', 'outcome_6': 'outcome', 'winner_7': 'winner', 'surface_8': 'surface', 'clay_9': 'clay', '4_10': '4'}
['outcome', 'date', 'tournament', 'surface', 'partner', 'opponents', 'score']
[['runner - up', '19 may 2009', 'antalya , turkey', 'clay', 'julia klackenberg', 'amanda carreras valentina sulpizio', '0 - 6 , 3 - 6'], ['runner - up', '22 june 2009', 'kristinehamn , sweden', 'clay', 'sofia arvidsson', 'hanne skak jensen johanna larsson', '6 - 7 ( 5 - 7 ) , 2 - 6'], ['winner', '29 june 2009', 'ystad , sweden', 'clay', 'sofia arvidsson', 'melanie klaffner hanna nooni', '6 - 4 , 6 - 4'], ['winner', '27 july 2009', 'tampere , finland', 'clay', 'emma laine', 'alizé lim vivienne vierin', '6 - 4 , 6 - 3'], ['winner', '7 may 2012', 'båstad , sweden', 'clay', 'eveliina virtanen', 'hilda melander paulina milosavljevic', '6 - 2 , 3 - 6 ,'], ['winner', '14 may 2012', 'båstad , sweden', 'clay', 'eveliina virtanen', 'lucy brown milana špremo', '6 - 3 , 6 - 7 ( 4 - 7 ) ,'], ['winner', '18 march 2013', 'sunderland , united kingdom', 'hard ( i )', 'hilda melander', 'amy bowtell lucy brown', '6 - 0 , 6 - 3']]