Table: top_singles_1986_canada
Columns: volume_issue
issue_date_s
weeks_on_top
song
artist

Question: What Volume:Issue that has Peter Cetera as the artist and was on top for longer than 1 week?
SQL: SELECT "volume_issue" FROM top_singles_1986_canada WHERE "weeks_on_top" > 1 AND "artist" = 'peter cetera'

Question: What is the longest weeks on top when the Artist was Bruce Hornsby and the Range?
SQL: SELECT MAX("weeks_on_top") FROM top_singles_1986_canada WHERE "artist" = 'bruce hornsby and the range'