mysql – Count different values ​​of a field

I am working with a GIS that supports mySQL queries. I have a map where each point represents a bird and a row with the attributes that are shown in the extract of the attribute table:

round | area | date | species | behavior
-------------------------------------------------- -------
1 | 20 | 2018-04-13 | woodpecker NULL
1 | 55 | 2018-04-14 | woodpecker NULL
1 | 21 | 2018-06-01 | robin NULL
1 | 55 | 2018-04-14 | NULL blackbird
1 | 55 | 2018-04-14 | NULL blackbird
1 | 55 | 2018-04-14 | robin NULL
2 | 55 | 2018-05-28 | NULL finch
2 | 20 | 2018-05-29 | NULL finch
3 | 21 | 2018-06-01 | robin race
3 | 55 | 2018-06-01 | NULL blackbird

Each study area was visited n times (see the column "round", where "round" is global.) That means that when we did not
find a single bird in a specific round, we have no entry for this area on this date, but the round will increase the next time you visit the area)

What I need is a table like the one below. I have no idea, how to do this with SQL. What I need is something like:

* Start with the lowest round
Get area and count the species for this area.
next area
next round *

The desired table:

area | round | date | woodpecker robin blackbird finch sum
-------------------------------------------------- ------------------------------
20 | 1 | 2018-04-13 | 1 | 0 | 0 | 0 | one
55 | 1 | 2018-04-14 | 1 | 1 | 2 | 0 | 4
21 | 1 | 2018-04-01 | 0 | 1 | 0 | 0 | one
20 | 2 | 2018-05-29 | 0 | 0 | 0 | 1 | one
55 | 2 | 2018-05-28 | 0 | 0 | 0 | 1 | one
21 | 3 | 2018-05-28 | 0 | 1 | 0 | 0 | one
55 | 3 | 2018-06-01 | 0 | 0 | 1 | 0 | one

Any ideas?