alirsLofty Part1
Updated 2022-07-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH LOFTYASSETS AS (
SELECT
asset_id,
asset_name,
total_supply,
created_at
FROM
algorand.asset
WHERE
creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
AND asset_deleted ='FALSE'
AND asset_id != 237267329 --Lofty AI
)
SELECT
count(asset_name) as number_Properties,
AVG(50*total_supply) as AveragePrice_USD
FROM
LOFTYASSETS
Run a query to Download Data