WITH new_old_users AS (
SELECT
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS new_users
FROM
base.nft.ez_nft_sales
WHERE
BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '7 days'
),
total_users AS (
SELECT
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS total_users
FROM
base.nft.ez_nft_sales
)
SELECT
new_users,
total_users,
NULLIF(new_users, 0) / NULLIF(total_users, 0) AS new_user_percentage
FROM
new_old_users, total_users;