Table: artist_sales
Columns: artist
country_of_origin
period_active
release_year_of_first_charted_record
genre
claimed_sales

Question: What was the genre of Queen (an artist from the United Kingdom)?
SQL: SELECT "genre" FROM artist_sales WHERE "country_of_origin" = 'united kingdom' AND "artist" = 'queen'

Question: What is the number of claimed sales in the rock genre?
SQL: SELECT "claimed_sales" FROM artist_sales WHERE "genre" = 'rock'

Question: What was the earliest release-year of the first charted record of Abba?
SQL: SELECT MIN("release_year_of_first_charted_record") FROM artist_sales WHERE "artist" = 'abba'

Question: What was the active period for the pop genre?
SQL: SELECT "period_active" FROM artist_sales WHERE "genre" = 'pop'