2008 in canadian music
the album ' my love : essential collection ' was the only canadian album to be certified 2x platinum .
{'scope': 'all', 'row': '3', 'col': '6', 'col_other': '3', 'criterion': 'equal', 'value': '2x platinum', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'certification', '2x platinum'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose certification record fuzzily matches to 2x platinum .', 'tostr': 'filter_eq { all_rows ; certification ; 2x platinum }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; certification ; 2x platinum } }', 'tointer': 'select the rows whose certification record fuzzily matches to 2x platinum . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'certification', '2x platinum'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose certification record fuzzily matches to 2x platinum .', 'tostr': 'filter_eq { all_rows ; certification ; 2x platinum }'}, 'album'], 'result': 'my love : essential collection', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; certification ; 2x platinum } ; album }'}, 'my love : essential collection'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; certification ; 2x platinum } ; album } ; my love : essential collection }', 'tointer': 'the album record of this unqiue row is my love : essential collection .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; certification ; 2x platinum } } ; eq { hop { filter_eq { all_rows ; certification ; 2x platinum } ; album } ; my love : essential collection } } = true', 'tointer': 'select the rows whose certification record fuzzily matches to 2x platinum . there is only one such row in the table . the album record of this unqiue row is my love : essential collection .'}
and { only { filter_eq { all_rows ; certification ; 2x platinum } } ; eq { hop { filter_eq { all_rows ; certification ; 2x platinum } ; album } ; my love : essential collection } } = true
select the rows whose certification record fuzzily matches to 2x platinum . there is only one such row in the table . the album record of this unqiue row is my love : essential collection .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'certification_7': 'certification', '2x platinum_8': '2x platinum', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'album_9': 'album', 'my love : essential collection_10': 'my love : essential collection'}
['rank', 'artist', 'album', 'peak position', 'sales', 'certification']
[['1', 'nickelback', 'dark horse', '1', '480000', '6x platinum'], ['2', 'simple plan', 'simple plan', '2', '200000', 'platinum'], ['3', 'celine dion', 'my love : essential collection', '2', '160000', '2x platinum'], ['4', 'the canadian tenors', 'the canadian tenors', '22', '80000', 'platinum'], ['5', 'city and colour', 'bring me your love', '3', '80000', 'platinum'], ['6', 'cur de pirate', 'cur de pirate', 'n / a', '80000', 'platinum'], ['7', 'sarah mclachlan', 'closer : the best of sarah mclachlan', '3', '80000', 'platinum'], ['8', 'theory of a deadman', 'scars & souvenirs', '2', '80000', 'platinum'], ['9', 'sam roberts', 'love at the end of the world', '1', '50000', 'gold'], ['10', 'tara oram', 'chasing the sun', '8', '50000', 'gold']]