Email Census

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

Domain

SQL

Difficulty

easy

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.

Practice This Problem

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