To get a list of the singers and the number of records for each singer (ie the number of songs) use:
select Singer, count(Singer) from Album group by Singer.
This assumes that there is only one record for each singer and song combination.
They say, best men are moulded out of faults,
And, for the most, become much more the better
For being a little bad.