LeetCode SQL Practice

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is LeetCode SQL Practice. Start with the requirements and the one table on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

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

Problem

Business Context

KPIT's Connected Engineering portal receives email addresses from employees and external collaborators. Different address formats can refer to the same mailbox, so reporting must count each valid destination only once.

Task

Write a PostgreSQL query that calculates the number of unique normalized email addresses in portal_emails.

Requirements

Remove every period from the local part before the @ symbol.
Ignore the plus suffix in the local part, including the + character and everything after it.
Count each normalized email address once and exclude rows where email is NULL.

Schema

portal_emails

Column	Type	Description
email_idPK	INT	Unique identifier for the submitted email row
email	VARCHAR(255)	Submitted email address

Tablesportal_emails

Your solutionPostgreSQL

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

Run a query to see results