list of songs in rock band
dirty little secret is the only song that is from the decade of the 2000s .
{'scope': 'all', 'row': '1', 'col': '3', 'col_other': '1', 'criterion': 'equal', 'value': '2000s', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'decade', '2000s'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose decade record fuzzily matches to 2000s .', 'tostr': 'filter_eq { all_rows ; decade ; 2000s }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; decade ; 2000s } }', 'tointer': 'select the rows whose decade record fuzzily matches to 2000s . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'decade', '2000s'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose decade record fuzzily matches to 2000s .', 'tostr': 'filter_eq { all_rows ; decade ; 2000s }'}, 'song title'], 'result': 'dirty little secret', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; decade ; 2000s } ; song title }'}, 'dirty little secret'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; decade ; 2000s } ; song title } ; dirty little secret }', 'tointer': 'the song title record of this unqiue row is dirty little secret .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; decade ; 2000s } } ; eq { hop { filter_eq { all_rows ; decade ; 2000s } ; song title } ; dirty little secret } } = true', 'tointer': 'select the rows whose decade record fuzzily matches to 2000s . there is only one such row in the table . the song title record of this unqiue row is dirty little secret .'}
and { only { filter_eq { all_rows ; decade ; 2000s } } ; eq { hop { filter_eq { all_rows ; decade ; 2000s } ; song title } ; dirty little secret } } = true
select the rows whose decade record fuzzily matches to 2000s . there is only one such row in the table . the song title record of this unqiue row is dirty little secret .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'decade_7': 'decade', '2000s_8': '2000s', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'song title_9': 'song title', 'dirty little secret_10': 'dirty little secret'}
['song title', 'artist', 'decade', 'genre', 'family friendly']
[['dirty little secret', 'all american rejects the all american rejects', '2000s', 'emo', 'yes'], ["do n't look back in anger", 'oasis', '1990s', 'rock', 'yes'], ['roam', "b - 52 's the b - 52 's", '1980s', 'pop / rock', 'yes'], ['rockaway beach', 'ramones', '1970s', 'punk', 'yes'], ['roxanne', 'police the police', '1970s', 'pop / rock', 'no']]