Aggregation with grouping
For each Artist, how many Albums?
Join Artist and Album and then count.
| artist |
artist_website |
title |
year |
label |
| Elvis Costello |
elviscostello.com |
My Aim Is True |
1977 |
Stiff |
| Elvis Costello |
elviscostello.com |
This Year's Model |
1978 |
Radar |
| Elvis Costello |
elviscostello.com |
Armed Forces |
1979 |
Radar |
| Elvis Costello |
elviscostello.com |
Get Happy!! |
1980 |
Columbia |
| Elvis Costello |
elviscostello.com |
Trust |
1981 |
Columbia |
| Elvis Costello |
elviscostello.com |
Almost Blue |
1981 |
F-Beat |
| Elvis Costello |
elviscostello.com |
Imperial Bedroom |
1982 |
Columbia |
| Elvis Costello |
elviscostello.com |
Punch the Clock |
1983 |
Columbia |
| Elvis Costello |
elviscostello.com |
Goodbye Cruel World |
1984 |
Columbia |
| Elvis Costello |
elviscostello.com |
King of America |
1986 |
Columbia |
| Elvis Costello |
elviscostello.com |
Blood and Chocolate |
1986 |
Columbia |
| The Detroit Cobras |
thedetroitcobras.com |
Mink Rat or Rabbit |
1998 |
Sympathy for the Record Industry |
| The Detroit Cobras |
thedetroitcobras.com |
Life, Love and Leaving |
2001 |
Sympathy for the Record Industry |
| The Detroit Cobras |
thedetroitcobras.com |
Seven Easy Pieces |
2003 |
Rough Trade |
| The Detroit Cobras |
thedetroitcobras.com |
Baby |
2004 |
Rough Trade |
| The Detroit Cobras |
thedetroitcobras.com |
Tied & True |
2007 |
Bloodshot |
| The Detroit Cobras |
thedetroitcobras.com |
The Original Recordings |
2008 |
Munster Records |
|