(왕왕왕초보의) 엑셀보다 쉬운 SQL - 1주차 <3(숙제)>

1-3) 1주차 숙제

 

# 퀴즈 1
select * from users
where name = '남**';
# * --> email로

# 퀴즈 2
select * from users
where email between '2020-07-12' and '2020-07-14' and email = '%gmail.com';
# email --> created_at , = --> like

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

# HW. 1주차
select * from orders
where email like '%naver.com' 
and course_title = '웹개발 종합반' 
and payment_method = 'kakaopay';