KaskoazulLofty Assets Stats
    Updated 2022-02-28
    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,
    median(50*total_supply) as MedianPrice_USD
    FROM
    LOFTYASSETS