No "number_of_albums Column" In Mediastore.audio.artists

I want to retrieve data from MediaStore especially the number of albums per artist but SQLite throws me an exception no such column: number_of_albums (code 1): while compiling:

Solution 1:

You're querying the wrong content URI for that column. Use MediaStore.Audio.Artists.EXTERNAL_CONTENT_URI instead of MediaStore.Audio.Media.EXTERNAL_CONTENT_URI.