I see what you are saying now, sorry about the confusion...
You are most likely looking for a count per singer of the number of songs for each.
SELECT SINGER, COUNT(*) FROM ALBUM GROUP BY SINGER
For more info on "GROUPING" - check out www.sqlteam.com
- they have a pretty decent site. The Wrox books are very good too.