> select count(*) as pocet_nod, year(node_created) as rok_vytvorenia, count(distinct node_creator) as pocet_autorov from nodes group by year(node_created) order by rok_vytvorenia;

+-----------+----------------+---------------+
| pocet_nod | rok_vytvorenia | pocet_autorov |
+-----------+----------------+---------------+
| 9805 | 2002 | 383 |
| 414114 | 2003 | 1338 |
| 634506 | 2004 | 2297 |
| 741962 | 2005 | 6911 |
| 727171 | 2006 | 3097 |
| 696203 | 2007 | 5180 |
| 819321 | 2008 | 4572 |
| 695085 | 2009 | 4047 |
| 635641 | 2010 | 3501 |
| 681632 | 2011 | 3339 |
| 574559 | 2012 | 3027 |
| 457107 | 2013 | 2705 |
| 350967 | 2014 | 2459 |
| 267763 | 2015 | 2111 |
| 209886 | 2016 | 1931 |
| 164091 | 2017 | 2705 |
| 141501 | 2018 | 2557 |
| 115146 | 2019 | 1199 |
| 127935 | 2020 | 1145 |
| 113445 | 2021 | 1050 |
| 93237 | 2022 | 924 |
| 85916 | 2023 | 886 |
| 90785 | 2024 | 840 |
+-----------+----------------+---------------+

> select year(date_last_login),count(*) from users group by year(date_last_login);

+-----------------------+----------+
| year(date_last_login) | count(*) |
+-----------------------+----------+
| 2006 | 44 |
| 2007 | 402 |
| 2008 | 404 |
| 2009 | 382 |
| 2010 | 307 |
| 2011 | 322 |
| 2012 | 312 |
| 2013 | 306 |
| 2014 | 268 |
| 2015 | 249 |
| 2016 | 194 |
| 2017 | 338 |
| 2018 | 180 |
| 2019 | 185 |
| 2020 | 229 |
| 2021 | 273 |
| 2022 | 242 |
| 2023 | 305 |
| 2024 | 786 |
| 2025 | 911 |
+-----------------------+----------+

Prva tabulka myslim hovori sama za seba. Druhu tabulku mozes citat nasledovnym sposobom: v roku 2025 sa zatial zalogovalo 911 ludi. Z tych ktori sa zalogovali v roku 2024 sa zatial 786 ludi nezalogovalo. Z tych ktori sa zalogovali v roku 2023 sa odvtedy nezalogovalo 305 ludi...atd.