Download, links counter

Hello support, is there any counter for Admin part in Nextcloud? I need to count how many times users will download specific link.

Downloads as in shared files?

yes, any shared files

There are no app. But can be made with some sql queries on the right sql table.

Please can you help, and show that query in the right table just like an example?
Thank you

Here is a good one

You can also see recent download activity from other users with a link like the following:

Install this app:

And then you can use something similar to this:

select file,count(*) from oc_activity where subject LIKE "%downloaded%" group by file;