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

junior

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.

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.