question: What is the longest weeks on top when the Artist was Bruce Hornsby and the Range?
answer: SELECT MAX(weeks_on_top) FROM table_name_74 WHERE artist = "bruce hornsby and the range"
context: CREATE TABLE table_name_74 (weeks_on_top INTEGER, artist VARCHAR)