WITH unique_minters AS (
SELECT
COUNT(DISTINCT nft_to_address) AS unique_minters -- get the unique addresses of the minters
-- DATE_TRUNC('day', block_timestamp) AS date
FROM ethereum.core.ez_nft_mints
WHERE
nft_address = lower('0x49c36AFa15C7Fdbd57cE3D61D80F39b6615A76Ef') --contract address for 3d Invisble Friends --
)
SELECT
(unique_minters / 5000 * 100) AS percent_unique_minters
FROM unique_Minters