What is the longest weeks on top when the Artist was Bruce Hornsby and the Range?
CREATE TABLE table_name_74 (
    weeks_on_top INTEGER,
    artist VARCHAR
)
SELECT MAX(weeks_on_top) FROM table_name_74 WHERE artist = "bruce hornsby and the range"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What is the longest weeks on top when the Artist was Bruce Hornsby and the Range? ### Input: CREATE TABLE table_name_74 (
    weeks_on_top INTEGER,
    artist VARCHAR
) ### Response: SELECT MAX(weeks_on_top) FROM table_name_74 WHERE artist = "bruce hornsby and the range"