https://www.tutlane.com/tutorial/sqlite/sqlite-count-function
SQLite COUNT() Function - Tutlane
SQLite count() function with example. In sqlite count() function is used to return number of rows in table based on specified expression.
sqlite countfunction