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"
<s>[INST] Write mssql query to answer the following question given the database schema. 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? [/INST] SELECT MAX(weeks_on_top) FROM table_name_74 WHERE artist = "bruce hornsby and the range" </s>