Try Quests to earn AVAXEVM - 17. Avalanche Gas Fees .
Create a dashboard to analyze gas usage on the Avalanche network. The dashboard should have two tabs: one for contracts and one for dApps. Each tab should show which ones generate the most network fees and use the most gas over a user-selectable time period. This query calculates the total network fees and gas usage for each contract during the time period from 2023-01-01 to 2023-03-27 and sorts them by network fees. It also selects the top 11 contracts with the highest network fees using LIMIT 11. You can replace the date values with your preferred date.