
October 23rd, 2012, 12:56 AM
|
|
Registered User
|
|
Join Date: Oct 2012
Posts: 3
Time spent in forums: 30 m 24 sec
Reputation Power: 0
|
|
|
SQL count query help
Okay the query I have been asked is to
"How many albums have been released by each label?
Do not display any NULL values.
Sort the ouput in ascending order of number of albums, and ascending order of label."
So far I have:
Code:
select title, label from album;
Which shows both the title of the album and the label its produced by, but what count function do I use and how to I implement it so I can have how many albums have been released by each label? Thank you
|