flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Untitled Query
Aryan
Untitled Query
Updated 2022-01-27
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
WITH
authors
AS
(
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
;
Results
Run a query to Download Data