Show all artists.
select * from artist
What are their names and year they joined?
select name, year_join from artist
Oh please just consider those who are not from United States.
select name, year_join from artist where country != 'United States'