Which are the male artists?
select * from artist where gender = "Male"
And which of them are from the UK?
select artist_name from artist where country = "UK" and gender = "Male"
Okay, and what genre does Michel prefer?
select preferred_genre from artist where artist_name = "Michel"
Alright, and how many male artists who prefer pop are there in the entire world, according to the table?
select count ( * ) from artist where preferred_genre = "pop" and gender = "Male"
How many female artists prefer pop?
select count ( * ) from artist where preferred_genre = "pop" and gender = "Female"
Finally, what is the most preferred genre in the entire world?
select preferred_genre from artist group by preferred_genre order by count ( * ) desc limit 1