Find the names of artists that do not have any albums.
create table artist (name varchar, PRIMARY KEY (name)); create table album (artistid varchar, PRIMARY KEY (artistid)); create table artist (name varchar, artistid varchar, PRIMARY KEY (name))
select name from artist except select t2.name from album as t1 join artist as t2 on t1.artistid = t2.artistid