1
Hello, I would like an SQL command for a query in a Access.
The structure of the table is:
tbList
Id | Nome | Genero | Endereco | Estado | ...
The result I would like to group by state and count the amount of genders (sex) in this way:
+-----------+----------+-----------+
| ESTADO | FEMININO | MASCULINO |
+-----------+----------+-----------+
| SP | 36 | 40 |
| RJ | 44 | 13 |
| MG | 17 | 23 |
...
...
Thank you in advance for your attention!
PS.: Sorry for anything wrong I’ve done, but I’m still learning how to use the stackoverflow!
Thank you! That’s right!
– Maux