How many artists have album?
select count ( distinct artistid ) from album
How many artists in this table?
select count ( distinct t1.artistid ) from artist as t1 join album as t2 on t1.artistid = t2.artistid where t1.name = 'Accept'
Yes.
select count ( * ) from album