From users, return COUNT(*) AS total, COUNT(DISTINCT age_bucket) AS distinct_buckets, and COUNT(age_

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

Domain

SQL

Difficulty

medium

Problem

From users, return COUNT(*) AS total, COUNT(DISTINCT age_bucket) AS distinct_buckets, and COUNT(age_bucket) AS non_null_buckets on one row. (DISTINCT ignores NULL.)

Practice This Problem

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