Where in the World Are Our Customers?

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

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

The go-to-market team assumes most of the customer base is domestic. Out of all customers, what percentage are based in the United States (customers.country = 'United States')? Return a single number rounded to 2 decimal places as us_share_pct.

Summary

One country dominates the logo wall. Or does it?

Practice This Problem

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