No Data to Display
Mrftiyour contracts
Updated 42 minutes ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
-- forked from remaining-black @ https://flipsidecrypto.xyz/studio/queries/831ebba2-1685-4297-a190-28a7136863cd
WITH tbl AS (
SELECT
creator_address AS "Address",
COUNT(*) as "Total Contracts Deployed",
RANK() OVER (ORDER BY COUNT(*) DESC) as deployer_rank
FROM monad.testnet.dim_contracts
GROUP BY creator_address
),
ranked_addresses AS (
SELECT
"Address",
"Total Contracts Deployed",
RANK() OVER (ORDER BY "Total Contracts Deployed" DESC) AS deployment_rank
FROM tbl
)
SELECT
"Address",
"Total Contracts Deployed",
deployment_rank AS "Address Rank by Contracts Deployed"
FROM
ranked_addresses
WHERE
"Address" = LOWER('{{Address}}');
Last run: 42 minutes agoAuto-refreshes every 12 hours
0
2B
1s