-- Grand Prize -- 34.091 NEAR (A score of 11 or 12 earns you a Grand Prize title) -- Payout -- 22.727 NEAR -- Score Multiplier -- 0-7 : 0% -- 8 : 50% -- 9 : 75% -- 10 : 100% -- 11 : 125% -- 12 : 150% -- Payout Network Near -- Level Intermediate -- Difficulty Hard -- Q10.Calculate the distribution of $NEAR holdings by address. -- In terms of charts, feel free to create a histogram or whichever visual you think works best! -- SQL Credit: https://app.flipsidecrypto.com/velocity/queries/b5965dc9-827a-4466-8ccc-c5e5d0d24aa9 WITH txns as ( -- +INFLOW SELECT TX_RECEIVER as wallet, SUM(deposit / pow(10, 24)) as val FROM near.core.fact_transfers WHERE STATUS = 'TRUE' GROUP BY 1 -- -OUTFLOW UNION ALL SELECT TX_SIGNER as wallet, -1 * SUM(deposit / pow(10, 24)) as val FROM near.core.fact_transfers WHERE STATUS = 'TRUE' GROUP BY 1 -- -TX Cost UNION ALL SELECT TX_SIGNER as wallet, -1 * SUM(transaction_fee / pow(10,24)) as val FROM near.core.fact_transfers WHERE STATUS = 'TRUE' GROUP BY 1 -- +Swap To NEAR (Increases NEAR balance) UNION ALL SELECT TRADER as wallet, SUM(AMOUNT_OUT) as val FROM near.core.ez_dex_swaps WHERE TOKEN_OUT = 'NEAR' GROUP BY 1 -- -Swap From NEAR (Reduces NEAR balance) UNION ALL SELECT TRADER as wallet, -1 * SUM(AMOUNT_IN) as val FROM near.core.ez_dex_swaps WHERE TOKEN_IN = 'NEAR' GROUP BY 1 -- +UnStake UNION ALL SELECT tx.TX_signer as wallet, SUM(TRY_PARSE_JSON(fc.ARGS):MIN_EXPECTED_NEAR::INTEGER / POW(10, 24)) as val FROM near.core.fact_transactions tx JOIN near.core.fact_actions_events_function_call fc ON fc.tx_hash = tx.tx_hash WHERE (METHOD_NAME ilike 'liquid_unstake' or METHOD_NAME ilike 'instant_unstake') GROUP BY 1 HAVING val > 0 -- -Stake UNION ALL SELECT tx.TX_signer as wallet, -1 * SUM(fc.deposit / POW(10, 24)) as val FROM near.core.fact_transactions tx JOIN near.core.fact_actions_events_function_call fc ON fc.tx_hash = tx.tx_hash WHERE METHOD_NAME IN ('deposit_and_stake', 'stake') GROUP BY 1 HAVING val > 0 -- +Multicall (NEAR Added to the wallet) UNION ALL SELECT TRY_PARSE_JSON(ac.VALUE):ACCOUNT_ID::STRING as wallet, SUM(TRY_PARSE_JSON(ac.VALUE):AMOUNT::INTEGER / POW(10, 24)) AS val FROM NEAR.CORE.FACT_ACTIONS_EVENTS_FUNCTION_CALL, table(flatten(TRY_PARSE_JSON(NEAR.CORE.FACT_ACTIONS_EVENTS_FUNCTION_CALL.ARGS):ACCOUNTS)) ac WHERE METHOD_NAME IN ('multisend_from_balance', 'multisend_from_balance_unsafe') GROUP BY 1 ), balances as ( SELECT wallet, SUM(val) as balance FROM txns group by wallet having balance > 0 ) select count(distinct wallet) as n_wallets, CASE WHEN balance > 0 and balance <= .1 THEN 'a.0-0.1' WHEN balance > 0.1 and balance <= 0.5 THEN 'b.0.1-0.5' WHEN balance > 0.5 and balance <= 1 THEN 'c.0.5-1' WHEN balance > 1 and balance <= 5 THEN 'd.1-5' WHEN balance > 5 and balance <= 10 THEN 'e.5-10' WHEN balance > 10 and balance <= 50 THEN 'f.10-50' WHEN balance > 50 and balance <= 100 THEN 'g.50-100' WHEN balance > 100 and balance <= 500 THEN 'h.100-500' WHEN balance > 500 and balance <= 1000 THEN 'i.500-1K' WHEN balance > 1000 and balance <= 5000 THEN 'j.1K-5K' WHEN balance > 5000 and balance <= 10000 THEN 'k.5K-10K' WHEN balance > 10000 and balance <= 100000 THEN 'l.10K-100K' WHEN balance > 100000 THEN 'm.> 100K' END as category from balances group by category order by category

Near-10.NEAR Distribution