How many weeks in the top 10 was spent by a song performed by Peter Kay?
CREATE TABLE table_27813010_2 (weeks_in_top_10 INTEGER, artist VARCHAR)
SELECT MAX(weeks_in_top_10) FROM table_27813010_2 WHERE artist = "Peter Kay"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_27813010_2 (weeks_in_top_10 INTEGER, artist VARCHAR) Question: How many weeks in the top 10 was spent by a song performed by Peter Kay? [/INST] SELECT MAX(weeks_in_top_10) FROM table_27813010_2 WHERE artist = "Peter Kay" </s>