SELECT COUNT(*) as apps_created, creator_address, MAX(created_at)

FROM algorand.app

-- WHERE created_at > 18000000

GROUP BY creator_address

SELECT * FROM authors

ORDER BY apps_created DESC

LIMIT 10

;