Table: canadian_1974_singles
Columns: volume_issue
issue_date_s
weeks_on_top
song
artist

Question: Which song by David Essex spent 2 weeks on top of the charts?
SQL: SELECT "song" FROM canadian_1974_singles WHERE "weeks_on_top" = 2 AND "artist" = 'david essex'

Question: What is the Volume:Issue number of the George McCrae song that spent less than 2 weeks on top of the charts?
SQL: SELECT "volume_issue" FROM canadian_1974_singles WHERE "weeks_on_top" < 2 AND "artist" = 'george mccrae'