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. to answer questions, for rank wallets based on trades, we find all swaps done last month on Sushiswap DEX using ethereum_core.ez_dex_swaps table. Then we join the result on ethereum_core.fact_transactions table on tx_hash field to find the number of trades and we get the number of trades for each address based on the transactions that have been successful. for rank wallets based on trading days, we do calculations like part 1 but with differences in grouping results. finally, we define loyal users and calculate number of loyal users on Sushiswap.