How many distinct countries are there?
select count(distinct country) from artist
How many artists come from India?
select count(*) from artist where country = 'India'
Which ones who come from UK and have songs in English?
select artist_name from artist where country = "UK" intersect select artist_name from song where languages = "english"