# select artist,count(title) from playlist group by artist order by count(title) desc; artist | count ------------------------------+------- Bob Dylan | 2478 John Hiatt | 2068 Bonnie Raitt | 1821 Van Morrison | 1679 Neil Young | 1679 Los Lobos | 1651 John Prine | 1530 James Mcmurtry | 1457 Bruce Springsteen | 1427 Todd Snider | 1410 Little Feat | 1392 Rolling Stones | 1350 Tom Petty | 1307 Greg Brown | 1275 Rodney Crowell | 1220 Eric Clapton | 1195 Subdudes | 1143 Bruce Cockburn | 1132 Grateful Dead | 1132 Steve Earle | 1114 Lucinda Williams | 1102 Robert Earl Keen | 1021 Los Lonely Boys | 982 Allman Brothers | 970 Stephen Stills | 955 John Mellencamp | 951 Widespread Panic | 937 Paul Thorn | 915 Dave Alvin | 896 The Band | 883 Jimmy Lafave | 866 Mark Knopfler | 861 Jackson Browne | 859 Tom Waits | 855 Shawn Colvin | 843 Ben Harper | 838 Keb Mo | 836 Susan Tedeschi | 813 Jackie Greene | 802 Guy Clark | 799 Ry Cooder | 797 Taj Mahal | 793 Chris Isaak | 789 Stevie Ray Vaughn | 780 Dire Straits | 779 Warren Zevon | 767 Johnny Cash | 743 Delbert Mcclinton | 741 Sam Bush | 741 Lyle Lovett | 738