Table: top_2010_singles_scotland
Columns: entry_date_a
single
artist
peak
peak_reached_a
weeks_in_top_10

Question: How many weeks in the top 10 was spent by a song performed by Peter Kay?
SQL: SELECT MAX("weeks_in_top_10") FROM top_2010_singles_scotland WHERE "artist" = 'Peter Kay'

Question: How long has the longest song spent in the top 10?
SQL: SELECT MAX("weeks_in_top_10") FROM top_2010_singles_scotland