What are the names of artists who are Male and are from UK?
SELECT artist_name FROM artist WHERE country  =  "UK" AND gender  =  "Male"
artists who are Male refers to gender = 'Male'; artists who are from UK refers to country = 'UK'; names of artists refers to SELECT artist_name;