Query editor
WITH all_users AS (SELECT DISTINCTDATE_TRUNC('month', ic.block_time) AS month,o.owner_account AS user_addressFROM solana.instruction_calls icINNER JOIN dune.whatsup1047.result_current_owners_v_2 oON element_at(ic.account_arguments, 3) = o.name_accountWHERE ic.executing_account = 'namesLPneVptA9Z5rqUDD9tMTWEJwofgaYwp8cawRkX'AND ic.tx_success = TRUEAND BYTEARRAY_TO_BIGINT(BYTEARRAY_SUBSTRING(ic.data, 1, 1)) = 0AND element_at(ic.account_arguments, 6) = '58PwtjSDuFHuUkYjH9BYnnQKHfwo9reZhC2zMJv9JPkx'AND ic.block_time >= DATE_TRUNC('month', DATE_ADD('month', -1, CURRENT_DATE))UNIONSELECT DISTINCTtrade_month AS month,trader_account AS user_addressFROM dune.solananameservice.result_active_users_secondary_sales_60_days)SELECTsum(CASE WHEN month = DATE_TRUNC('month', CURRENT_DATE) THEN 1 ELSE 0 END) AS current_month_users,sum(CASE WHEN month = DATE_TRUNC('month', DATE_ADD('month', -1, CURRENT_DATE)) THEN 1 ELSE 0 END) AS previous_month_users,count(DISTINCT CASE WHEN month = DATE_TRUNC('month', CURRENT_DATE) THEN user_address END) -count(DISTINCT CASE WHEN month = DATE_TRUNC('month', CURRENT_DATE)AND user_address IN (SELECT user_address FROM all_usersWHERE month = DATE_TRUNC('month', DATE_ADD('month', -1, CURRENT_DATE))) THEN user_address END) AS new_usersFROM all_users