I have a table

```
ID|VALUE

```

VALUE is an integer field with possible values between 0 and 4. How can I query the count of each value?

Ideally the result should be an array with 6 elements, one for the count of each value and the last one is the total number of rows.