SQL Sign-Up Trends Query | Dataford Interview Questions

Write a SQL query to extract user sign-up trends over the last quarter on Quizlet.

Return monthly sign-up counts for each acquisition source during the most recently completed calendar quarter. Use the users and signup_sources tables.

Output

One row per month and acquisition source, including sources with zero sign-ups
Columns: signup_month, acquisition_source, and signup_count
Include all three months in the quarter and order by month ascending, then acquisition source ascending

Schema

users

Column	Type	Description
user_idPK	INT	Unique Quizlet user identifier
email	VARCHAR(255)	User email address
signed_up_at	TIMESTAMP	Timestamp when the user created an account
source_id	INT	Acquisition source associated with the sign-up

signup_sources

Column	Type	Description
source_idPK	INT	Unique acquisition source identifier
source_name	VARCHAR(100)	Name of the acquisition source

Your question is SQL Sign-Up Trends Query. 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