nicnicGetting Started

    -- Get started with Flipside by running your first query:
    -- the SQL statement below will get you a list of NFT
    -- projects on Ethereum, ranked by how many mints
    -- they've had in the past week.

    -- Be sure to see our documentation for more guidance,
    -- including a full walkthrough of the app:
    -- https://docs.flipsidecrypto.com/our-app/getting-started

    select
    project_name,
    count(*) as mint_count
    from
    ethereum.core.ez_nft_mints
    where
    project_name is not null
    and block_timestamp > current_date - interval '7 days'
    group by
    project_name
    order by
    mint_count desc
    limit
    8;