Extract Domain From Emails

EasySQL · PostgreSQL

Write a SQL query to extract the domain name from a column containing raw email addresses.

Use the email_records table and handle leading or trailing whitespace, mixed-case addresses, NULL values, and malformed entries.

Output

One row per valid email record, with columns id, raw_email, and domain_name.
Exclude NULL, blank, and malformed email values.
Normalize domains to lowercase and order results by id ascending.

email_records

Column	Type	Description
idPK	INT	Unique email record identifier
raw_email	VARCHAR(255)	Raw email address, which may contain whitespace, mixed case, or invalid values

Tablesemail_records

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.