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 assembling a clean outreach roster and wants the 'admin' and 'system' accounts left out, along with anyone whose email carries a 'z' anywhere (a known test-account marker). Keep every other user, including those who have no email on record yet, and return each remaining profile in full, 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.