JavaScript is required for SkillDojo AI to work properly. Please enable JavaScript and refresh the page.

Signup Conversion Rate by Region | Algorithm

MediumjoinsSQL

Signup Conversion Rate by Region

The marketing team wants to understand which regions are most effective at converting new signups into paying customers. For each region that had at least 5 orders in total, calculate the signup-to-order conversion rate, defined as the total number of orders divided by the total signup_count for all available days. Only include regions where at least one corresponding signup record exists for the days with sales. Order the results by the highest conversion rate first.

Return

region : the sales region total_orders : sum of orders for that region total_signups : sum of signup_count for all days with sales in that region conversion_rate : the ratio of total_orders to total_signups Only include regions with at least 5 total orders and at least one matching signup record. Order by conversion_rate descending.

Expected output

region	total_orders	total_signups	conversion_rate
US	885	2754	0.3213507625272331
GB	773	2754	0.2806826434277415
DE	731	2754	0.2654320987654321

First 3 of 5 rows your query should return. Your column aliases don't need to match.

Ctrl+Enter to run

Run your query to see results here.