Email Census

A easy SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

The CRM team is sizing their outreach lists before the next campaign. Segment every user account into one of two groups: those with an email address on file and those without. For each segment, show how many users fall into each bucket and what share of all users that segment represents, expressed as a percentage rounded to one decimal place. List the larger segment first.

Summary

The reachability split.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.