Liczba publikacji w poszczególne lata i dni (tab)

SQL

select
	substr(rev_timestamp, 5, 4) as "DZIEŃ",
    if(substr(rev_timestamp, 1, 4) = 2019,
       (select count(rev_id)
        from revision
        where substr(rev_timestamp, 1, 4) = 2019
        ), "hmm") as "l2019",
    if(substr(rev_timestamp, 1, 4) = 2020,
       (select count(rev_id)
        from revision
        where substr(rev_timestamp, 1, 4) = 2020
        ), "hmm") as "l2020",
    if(substr(rev_timestamp, 1, 4) = 2021,
       (select count(rev_id)
        from revision
        where substr(rev_timestamp, 1, 4) = 2021
        ), "hmm") as "l2021",
    if(substr(rev_timestamp, 1, 4) = 2022,
       (select count(rev_id)
        from revision
        where substr(rev_timestamp, 1, 4) = 2022
        ), "hmm") as "l2023",
    if(substr(rev_timestamp, 1, 4) = 2023,
       (select count(rev_id)
        from revision
        where substr(rev_timestamp, 1, 4) = 2023
        ), "hmm") as "l2023"
    from revision
    group by 1
    order by 1;
SQL

Checking query status...
