This is a recipe book of SQL tricks meant to serve as a reference for data analysts. There's no particular order to reading these recipes – each one starts with an applicable business case. Start with the most pressing business decision you are facing, and solve it by using the SQL recipe as a template.
Active Addresses For A Project
Transaction Count For A Project
Transaction Count For An Event
Smart Contract Creation Transactions
Stickiness Ratio For A Project (DAU/MAU)