0
I have two tables. A call Pessoa
and another call Evento
.
Pessoa
owns the fields id
, name
and email
.
Evento
owns the fields id
and pessoa_id
.
The table Evento
contains several events for each Pessoa
.
I would like to group all the people, and the amount of events related to it. The new table would be:
| Pessoa | Email | Quantidade Eventos |
| nome1 | [email protected] | 5 |
| nome2 | [email protected] | 10 |