Your view uses a [window function][1] `OVER (PARTITION BY', which may not be supported by the SQLite version on Android < v11, or by aSQLiteManager on those versions. Use [SELECT sqlite_version()][2] to find out what version your target Android version has installed, and consult the [release history][3] to find out if that version is supposed to support window functions. [1]: https://www.sqlite.org/windowfunctions.html#introduction_to_window_functions [2]: https://www.sqlite.org/lang_corefunc.html#sqlite_version [3]: https://www.sqlite.org/changes.html