SELECT max(balance_date) AS max_balance_date

FROM ethereum.erc20_balances

WHERE contract_address = '0x7e9d8f07a64e363e97a648904a89fb4cd5fb94cd'

AND balance_date > '2022-03-20'

SELECT CASE WHEN balance < 100 THEN '1) No Signal Access (FF Balance<100)'

WHEN balance < 1000 THEN '2) Signal Access (100 < FF Balance < 1000)'

ELSE '3) Discord and Signal Access (FF Balance >= 1000)' END AS token_tier

, COUNT(DISTINCT user_address) AS number_users

FROM ethereum.erc20_balances e

JOIN max_date m

ON m.max_balance_date = e.balance_date

WHERE contract_address = '0x7e9d8f07a64e363e97a648904a89fb4cd5fb94cd'

AND balance_date > '2022-03-20'

GROUP BY 1

ORDER BY 1