Group by date, make count for different conditions for each date in one query. Really?

Question

MySQL

There is a table with events of different types. You need to display how many events of each type were in a certain time interval. For example by day. The time of each event in the table is stored in UNIX format. Is it possible to fit this into 1 request?

Answer 1

something like this