15. Employee Email Verification

Grokking SQL for Tech Interviews

Ask Author

Back to course home

0% completed

Table of Contents

Contents are not accessible

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!

Table of Contents

Contents are not accessible