Checking Email Validity

List users whose email matches the regex ^[A-Za-z][A-Za-z0-9._-]*@[A-Za-z0-9.-]+\.[A-Za-z]{2,}$: exactly one @, the local part starts with a letter and contains only letters/digits/./_/-, and the domain ends with . plus at least 2 letters. Return user_id and email.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables. Your answer must use the same column names as this sample — alias them with AS if needed.

user_id	email
1	alice@example.com
3	charlie@example.net
4	david@domain.com

Your query result will appear here

Focus radio

Paused · SomaFM · Fluid