How many artists come from India?
select count(*) from artist where country = "India"
How about UK?
select count(*) from artist where country = "UK"
Among those artists, who are male?
select artist_name from artist where country = "UK" and gender = "Male"