Checking Email Validity

#540

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.

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

Your query result will appear here

Focus radio

Paused · SomaFM · Fluid