alirsLofty Part1
    Updated 2022-07-14
    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