java.lang.IllegalArgumentException: Invalid column COUNT(*) AS count

    at android.database.sqlite.SQLiteQueryBuilder.computeSingleProjectionOrThrow(SQLiteQueryBuilder.java:1142)

    at android.database.sqlite.SQLiteQueryBuilder.computeProjection(SQLiteQueryBuilder.java:1113)

    at android.database.sqlite.SQLiteQueryBuilder.buildQuery(SQLiteQueryBuilder.java:888)

    at android.database.sqlite.SQLiteQueryBuilder.query(SQLiteQueryBuilder.java:561)

    at com.android.providers.media.MediaProvider.queryInternal(MediaProvider.java:2423)

    at com.android.providers.media.MediaProvider.query(MediaProvider.java:2169)

    at android.content.ContentProvider$Transport.query(ContentProvider.java:271)

    at android.content.ContentProviderNative.onTransact(ContentProviderNative.java:104)

    at android.os.Binder.execTransactInternal(Binder.java:1021)

    at android.os.Binder.execTransact(Binder.java:994)

  --------- beginning of crash

2020-08-14 15:08:48.900 1607-2100/com.example.rongxuanapp E/AndroidRuntime: FATAL EXCEPTION: ModernAsyncTask #1

  Process: com.example.rongxuanapp, PID: 1607

  java.lang.RuntimeException: An error occurred while executing doInBackground()

    at androidx.loader.content.ModernAsyncTask$3.done(ModernAsyncTask.java:164)

    at java.util.concurrent.FutureTask.finishCompletion(FutureTask.java:383)

    at java.util.concurrent.FutureTask.setException(FutureTask.java:252)

    at java.util.concurrent.FutureTask.run(FutureTask.java:271)

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)

    at java.lang.Thread.run(Thread.java:919)

   Caused by: java.lang.IllegalArgumentException: Invalid column COUNT(*) AS count

    at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:170)

    at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:140)

    at android.content.ContentProviderProxy.query(ContentProviderNative.java:423)

    at android.content.ContentResolver.query(ContentResolver.java:963)

    at android.content.ContentResolver.query(ContentResolver.java:898)

    at androidx.core.content.ContentResolverCompat.query(ContentResolverCompat.java:81)

    at androidx.loader.content.CursorLoader.loadInBackground(CursorLoader.java:63)

    at com.zhihu.matisse.internal.loader.AlbumLoader.loadInBackground(AlbumLoader.java:97)

    at com.zhihu.matisse.internal.loader.AlbumLoader.loadInBackground(AlbumLoader.java:33)

    at androidx.loader.content.AsyncTaskLoader.onLoadInBackground(AsyncTaskLoader.java:307)

    at androidx.loader.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:60)

    at androidx.loader.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:48)

    at androidx.loader.content.ModernAsyncTask$2.call(ModernAsyncTask.java:141)

    at java.util.concurrent.FutureTask.run(FutureTask.java:266)

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) 

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) 

    at java.lang.Thread.run(Thread.java:919) 

你确定这Log是你应用的吗？为什么要截图呢，贴完整的log不可以吗？

如果是你的，那就是sql语句的问题呗，你可以使用API，或者第三方框架。如果是手写的话，需要用sqliteExploer验证完再用。