select toDate(timestamp) as date, code, sum(count) from firebase_errors where date > '2025-02-25' group by date, code order by date;daily group by firebase
select toDate(timestamp) as date, uuid, sum(count) from firebase_errors where date > '2025-02-25' group by date, uuid order by date;for a specific firebase accounts (bts00)
select toDate(timestamp) as date, code, sum(count) from firebase_errors where uuid in ['c288dcf0-64c8-44cf-bfe8-d3df1de42abe', 'bb135a16-6afe-414e-b487-7a4507591a04', 'f2fb4e90-00d1-487f-a8a8-5bce9be459f4', '0be6c5ac-4490-467b-8ad6-201596cfb8b3', '666d0d92-37ff-4bfd-ad4c-fd2caa59ad1e', 'b02309e5-af2d-44f1-8231-c51b592bec16', '077af9ad-bd24-471c-90c2-71f9db6190d3', 'bdd26605-fcf7-4972-bd2a-694876174470', '0a8aa6a9-c737-4c1b-ba13-4e3fa684d1b7', '6c276e22-f125-4aa7-bf93-e95a7ed75096', '7944a982-0422-4102-a65f-14089056d576', '83eb897d-34f6-4330-9c80-9a348f5de4e1', '6fd348c7-f4df-467a-b541-9e164200e0ee', '9f6a81e7-6ab7-444c-8440-abc71c8c2319', '1e087e88-16a4-47de-a0dd-e692e1bf3b60', 'c501fad0-3dd8-4d72-926c-60c52fe602e4', '4b2ada53-2ea0-477c-a00d-1c7400d0b33c', '22808fa1-e23b-4fa6-aca2-0131e3c43170', '884ddf24-b962-44e5-8f63-3fa708e5d01b', '83ddb47d-f697-4078-aca2-b7588c0251bd', '04a4177e-d2a0-4372-bd59-0a417597e5a3'] group by date, code order by date;