Return date quantity in Mysql

Question

I have the table containing the date field.

| Data|
| 2016-06-09   |
| 2016-06-09   |
| 2016-06-09   |
| 2016-06-08   |
| 2016-06-08   |
| 2016-06-05   |
| 2016-06-01   |

I want you to come back more or less like this:

| Data | Quantidade |
| 2016-06-09 | 3 |
| 2016-06-08 | 2 |
| 2016-06-05 | 1 |
| 2016-06-01 | 1 |

Answer 1

Use the COUNT and the GROUP BY:

SELECT `Data`, COUNT(`Data`) AS 'Quantidade' FROM sua_tabela
GROUP BY `Data`;