Count number of records for each id in SQLite?

Question

SQLite

Greetings friends!
There is a table:

manager_id | order_id | shop_id| timestamp 
----------------------------------------------------------
1                  |   23        |    1       | 1564057776
1                  |   28        |    1       |1564059420
2                  |   34        |    1       |1564060327

Each time an order is created, a record is created in the table. We need to build a rating of managers - by the number of orders._
That is, get the following result at the output:

manager_id|orders
---------------------------
1                |     2
2                |     1

The manager with id 1 placed 2 orders, and the manager with id 2 only placed 1.
Is it possible to get such an answer by writing a single request? Or will it be necessary to separately receive the number of records in a separate request for each manager and programmatically build a rating based on this data?
Thanks for the help!

Answer 1

You can use the sql COUNT function: 2sql.ru/novosti/sql-count
Here is your problem: https://stackoverflow.com/questions/7053902/sql-ho...