# $1517. 查找拥有有效邮箱的用户
# https://leetcode-cn.com/problems/find-users-with-valid-e-mails/

# SQL架构
Create table If Not Exists Users (user_id int, name varchar(30), mail varchar(50));
Truncate table Users;
insert into Users (user_id, name, mail) values ('1', 'Winston', 'winston@leetcode.com');
insert into Users (user_id, name, mail) values ('2', 'Jonathan', 'jonathanisgreat');
insert into Users (user_id, name, mail) values ('3', 'Annabelle', 'bella-@leetcode.com');
insert into Users (user_id, name, mail) values ('4', 'Sally', 'sally.come@leetcode.com');
insert into Users (user_id, name, mail) values ('5', 'Marwan', 'quarz#2020@leetcode.com');
insert into Users (user_id, name, mail) values ('6', 'David', 'david69@gmail.com');
insert into Users (user_id, name, mail) values ('7', 'Shapiro', '.shapo@leetcode.com');

# Write your MySQL query statement below
select
    user_id,
    name,
    mail
from
    Users
where
    mail regexp '^[a-zA-Z][a-zA-Z0-9_\\./-]*@leetcode\\.com$';

# clean-up
drop table Users;