Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
15. Employee Email Verification
On this page

Problem

Table: Employees

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| employee_id   | int     |
| name          | varchar |
| email         | varchar |
+---------------+---------+
employee_id is the primary key (column with unique values) for this table.
This table contains information about employees in a company. Some emails are invalid.

Problem Definition

Write a solution to identify the employees who have valid emails.

A valid email should have a username and a domain with the following rules:

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page