Table: canadian_music_2007
Columns: rank
artist
album
peak_position
sales
certification

Question: what is the rank when the album is sean kingston?
SQL: SELECT "rank" FROM canadian_music_2007 WHERE "album" = 'sean kingston'

Question: how many times is the rank less than 6, certification 2x platinum and the peak position 2?
SQL: SELECT COUNT("sales") FROM canadian_music_2007 WHERE "rank" < 6 AND "certification" = '2x platinum' AND "peak_position" = '2'

Question: what is the lowest rank when the peak position is 2, certification is platinum and the album is my december?
SQL: SELECT MIN("rank") FROM canadian_music_2007 WHERE "peak_position" = '2' AND "certification" = 'platinum' AND "album" = 'my december'

Question: What is the sales when the artist is kelly clarkson?
SQL: SELECT COUNT("sales") FROM canadian_music_2007 WHERE "artist" = 'kelly clarkson'