Help with a query
im supposed to Show the names of all artists which have at least one female member each. Use one or more subqueries. Do not use any joins. heres a link to the database diagram
im having a real hard time with these subqueries , so far what i have pretty much just finds the artists that have female members.
select artistname from artists where artistid in (select artistid from xrefartistsmembers where memberid in (select memberid from members where gender="f"));
sorry, what is the difference between "artists that have female members" and "all artists which have at least one female member each"? those sound like the same thing.