Week1 Quiz

Return emails of those whose family name is Nam.

hint: Users table

select email from users
where name = '남**'

Return names of those who are using Gmail and joined during 2020/07/12-2020/07/13.

hint: Users table

select name from users
where created_at between '2020-07-12' and '2020-07-14' 
and email like '%gmail.com'

Count the number of those who are using Gmail and joined during 2020/07/12-2020/07/13.

select count(*) from users
where created_at between '2020-07-12' and '2020-07-14' 
and email like '%gmail.com'