fb3ce38c-7bfe-475c-bca8-3f1e44ae80a62023-06-17 08:27 PM
Updated 2023-06-18
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
›
⌄
SELECT
CASE WHEN value LIKE '%Luke Skywalker: Red 5%' THEN 'Luke Skywalker: Red 5'
WHEN value LIKE '%Luke Skywalker: Farmboy%' THEN 'Luke Skywalker: Farmboy'
WHEN value LIKE '%Leia Organa: Bespin Escape%' THEN 'Leia Organa: Bespin Escape'
WHEN value LIKE '%Darth Vader: Sith Lord%' THEN 'Darth Vader: Sith Lord'
WHEN value LIKE '%Jedi Lightsaber%' THEN 'Luke Skywalker Jedi Lightsaber'
WHEN value LIKE '%Jedi Knight%' THEN 'Luke Skywalker Jedi knight'
WHEN value LIKE '%Darth Vader: Damaged Helmet%' THEN 'Darth Vader: Damaged Helmet'
ELSE NULL
END NFT_Type,
COUNT(*)
FROM
flow.core.fact_events,
LATERAL FLATTEN(input => event_data) AS kv
WHERE
EVENT_CONTRACT = 'A.ca63ce22f0d6bdba.Cryptoys'
AND event_type = 'Minted'
AND tx_succeeded = 'true'
AND block_timestamp > '2023-05-01'
AND key ='metadata'
AND value LIKE '%Star Wars%'
AND NFT_Type IS NOT NULL
GROUP BY NFT_type
LIMIT 100;
Run a query to Download Data