aycg2024-03-20 03:52 PM
    SELECT project_name,creator_fee_usd
    FROM ethereum.nft.ez_nft_sales s1
    WHERE EXISTS
    (SELECT 1
    FROM ethereum.nft.ez_nft_sales s2
    WHERE s2.creator_fee_usd > 100
    AND s1.project_name=s2.project_name);