SQL
AخA
SELECT
CONCAT(ROW_NUMBER() OVER(ORDER BY count(*) DESC),'.') AS 'Rank',
actor_name as thanking_last_year, COUNT(*) as count
FROM
logging, actor_user
WHERE
actor_id = log_actor and
log_type = "thanks" AND
log_title = "Nemoralis"
GROUP BY
actor_name
ORDER BY
count DESC, actor_name
LIMIT
100;
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.