I have this order table, I need to count the total requests of each user and the total requests of each user in the current month.
| id | id_user | name | data_criacao |
| 1 | 10 |Pedro | 2018-05-01 |
| 2 | 10 |Pedro | 2018-05-03 |
| 3 | 15 |Joao | 2018-05-04 |
| 4 | 10 |Pedro | 2018-05-10 |
| 5 | 18 |Maria | 2018-05-07 |
I made this select
which brings the name and total of requests of each user, however I need to bring the total of requests of each user in the current month, but I can not.
select name, count(*) as total from pedidos group by id_user;