Table schema:
CREATE TABLE table_name_74 (weeks_on_top INTEGER, artist VARCHAR)

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