Table: scotch_chart_data
Columns: title
album
country
peak_position
weeks_on_chart

Question: What is the title of the single with the peak position of 10 and weeks on chart is less than 19?
SQL: SELECT "title" FROM scotch_chart_data WHERE "peak_position" = 10 AND "weeks_on_chart" < 19

Question: what is the weeks on chart for the single from france?
SQL: SELECT "weeks_on_chart" FROM scotch_chart_data WHERE "country" = 'france'

Question: what is the country with the album best of and weeks on chart is less than 5?
SQL: SELECT "country" FROM scotch_chart_data WHERE "album" = 'best of' AND "weeks_on_chart" < 5

Question: What is the title of the single with the peak position of 10 and from France?
SQL: SELECT "title" FROM scotch_chart_data WHERE "peak_position" = 10 AND "country" = 'france'

Question: what is the most weeks on chart when the peak position is less than 5 and from Sweden?
SQL: SELECT MAX("weeks_on_chart") FROM scotch_chart_data WHERE "peak_position" < 5 AND "country" = 'sweden'