Write a SQL query to find the monthly active developers from a mock database of smart contract interactions.
Use the developers and contract_interactions tables. Count a developer as active in a month when they have at least one successful interaction during that calendar month.
month and active_developersmonth| Column | Type | Description |
|---|---|---|
| developer_idPK | INT | Unique identifier for a developer |
| wallet_address | VARCHAR(42) | Blockchain wallet address associated with the developer |
| developer_name | VARCHAR(100) | Display name of the developer |
| Column | Type | Description |
|---|---|---|
| interaction_idPK | INT | Unique identifier for an interaction |
| wallet_address | VARCHAR(42) | Wallet address that initiated the interaction |
| contract_address | VARCHAR(42) | Smart contract address involved in the interaction |
| interacted_at | TIMESTAMP | Timestamp when the interaction occurred |
| status | VARCHAR(20) | Interaction result status |