Table: canadian_music_2008_2
Columns: rank
artist
album
peak_position
sales
certification

Question: Which artist had a 4x platinum?
SQL: SELECT "artist" FROM canadian_music_2008_2 WHERE "certification" = '4x platinum'

Question: What was the highest peak position for the album one of the boys?
SQL: SELECT MAX("peak_position") FROM canadian_music_2008_2 WHERE "album" = 'one of the boys'

Question: How many sales had a peak position of 1 and a certification of 6x platinum?
SQL: SELECT COUNT("sales") FROM canadian_music_2008_2 WHERE "peak_position" = 1 AND "certification" = '6x platinum'

Question: What album had a peak position of 6 and a certification of 3x platinum?
SQL: SELECT "album" FROM canadian_music_2008_2 WHERE "certification" = '3x platinum' AND "peak_position" = 6

Question: How many sales had a peak position more than 2 and a Certification of 3x platinum?
SQL: SELECT COUNT("sales") FROM canadian_music_2008_2 WHERE "peak_position" > 2 AND "certification" = '3x platinum'