Try Quests to earn cryptoSushiswap Bounties (Sushiswap DEX Loyal Users)
Description of work: Rank wallets that used SushiSwap based on the number of trades and number of days they used the DEX so ---> To address this question, we use the ethereum_core schema First step ---> Get all swaps on Sushiswap from `[ethereum_core.ez_dex_swaps]` table Second step ---> get the number of trades and number of days they in the Last month, Year and since inception`[ethereum_core.fact_transactions]` table. Last step: Find the how many users keep coming back to the platform (Sushiswap DEX Loyal Users). ---> My definition of Loyal Users: Among the addresses obtained, Loyal Users are addresses that have had at least one sushi swap trade in the past week. NOTE 1: For find Loyal Users, we filter all dates based on one week before the current date ---> `[block_timestamp < current_date - 8]`. NOTE 2: For a better comparison we have get the top 50 for wallet for each number of trades and number of days in he Last month, Year and since inception, because a large number of records are obtained in this question