High-Level SQL Logic Question | Dataford Interview Questions

A company acquired 100 new customers in January and 90 in February. Considering that the first quarter average was 100 new customers, how many customers did the company acquire in March?

Use the monthly_customer_acquisitions table and write a query that calculates the missing March value from the January and February records.

Output

Return one row with a column named march_new_customers.
Return the calculated number of customers acquired in March.

Schema

monthly_customer_acquisitions

Column	Type	Description
record_idPK	INT	Unique record identifier
month_start	DATE	First day of the acquisition month
quarter_label	VARCHAR(2)	Calendar quarter label
new_customers	INT	Number of customers acquired during the month
quarter_average	INT	Average monthly customer acquisitions for the quarter

Your question is High-Level SQL Logic Question. Start with the requirements and the one table 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