SQL
x
SELECT log_title AS thankee, COUNT(*) AS number
FROM logging lg
WHERE log_type='thanks'
AND (log_timestamp BETWEEN '20210000000000' AND '20220000000000')
GROUP BY thankee
ORDER BY number DESC
LIMIT 10;
SELECT actor_name AS thanker, COUNT(*) AS number
FROM logging lg
INNER JOIN actor ON actor.actor_id=lg.log_actor
WHERE log_type='thanks'
AND (log_timestamp BETWEEN '20210000000000' AND '20220000000000')
GROUP BY thanker
ORDER BY number DESC
LIMIT 10;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.