Filtered User Roster

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 growth team is building a clean user roster for outreach, but the 'admin' and 'system' accounts need to be excluded, as do users with a 'z' anywhere in their email address (a known test-account pattern). Return every remaining user's full profile, alphabetical by username.

Summary

A clean roster for the all-hands.

Practice This Problem

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