How to view Firebase Cloud Messaging statistics by messages?

Question

MySQL

Has anyone used Firebase Cloud Messaging?
In presentations, everything is always so cool, but then in life, then half is not in the documentation, and the rest you need to write yourself from scratch.
They stated that the built-in Analytic system.
How realistic it is then to look at:

• how many subscribers
  
• for each posting
  
• how much did it turn out
  
• how many unsubscribed
  
• how many messages did not reach
  

this was not in Google Cloud Messaging
if there are any ready-made solutions such as paid CMS, throw those links plz

Answer 1

1) disable the ONLY_FULL_GROUP_BY mode, for example,
select @@sql_mode;
set @@sql_mode='list other modes without ONLY_FULL_GROUP_BY';
2) it is better to rewrite the query so that in the select part the fields that are not grouped by go using aggregate functions. There are at least 5 solutions, see the article Grouping in MySQL

Answer 2

Turn STRICT mode on mysql server off. And then your query is not unambiguous according to the results after grouping by only one field.