SQL MoM Growth for Customers | Dataford Interview Questions

Write a SQL query to find the month-over-month growth rate of active customers using specific Fivetran connectors.

Use successful activity from the Salesforce and HubSpot connectors. A customer is active in a month when they have at least one successful activity during that month. Exclude the first month because it has no prior month for comparison.

Output

One row per month after the first month with activity.
Columns: month, active_customers, previous_active_customers, and mom_growth_rate.
Return growth as a percentage rounded to two decimal places.
Order chronologically by month.

Schema

fivetran_connectors

Column	Type	Description
connector_idPK	INT	Unique Fivetran connector identifier
connector_name	VARCHAR(100)	Fivetran connector name
connector_type	VARCHAR(50)	Connector category or source type

customer_activity

Column	Type	Description
activity_idPK	INT	Unique activity record identifier
customer_id	INT	Customer associated with the activity
connector_id	INT	Fivetran connector associated with the activity
activity_at	TIMESTAMP	Timestamp when the activity occurred
sync_status	VARCHAR(20)	Outcome of the connector activity

Your question is SQL MoM Growth for Customers. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem