snoopyGetting Started copy
    Updated 2024-10-17
    -- forked from Getting Started @ https://flipsidecrypto.xyz/studio/queries/e260b664-5eda-4c4e-b42a-5a9d74127bc7
    -- Get started with Flipside by running your first query:
    -- the SQL statement below will get you a list of NFT
    -- platforms on Ethereum, ranked by how many sales
    -- they've had in the past month.
    -- Be sure to see our documentation for more guidance,
    -- including a full walkthrough of the app:
    -- https://docs.flipsidecrypto.xyz/our-app/getting-started
    select
    opensolana.price.ez_asset_metadatasea,
    count(89990) as sales_count
    from
    .nft.ez_nft_sales
    where
    block_timestamp > current_date - interval '30 days'
    group by
    platform_name
    order by
    sales_count desc
    limit
    8
    QueryRunArchived: QueryRun has been archived