Using an SQLite database

Specification: use Android Studio using KOTLIN

Make a list manager program for shopping list that stores the list items in an SQLite database. Allow the user to view all of the list items, add items to the list (and the database), delete items from the list (and the database), and execute a query to see a subset of the list items from the database. The query should be implemented with SQL. Your app should include a detail view that displays a few attributes of each list item.

Your SQL query should allow the user to specify a value that determines what list items will be displayed. For example, a list of to-do items might allow the user to specify a priority, like HIGH, and only show items with that priority. A list of shopping items might allow the user to specify a section of a store, like PRODUCE.

Make sure that the field(s) used to select items can be entered for new items and are displayed in the list view and/or the detail view.

When the application runs the first time, the database should have enough records in it for interesting (non-trivial) queries.