I. 성이 남씨인 유저의 이메일만 추출하기

  • SELECT email FROM users WHERE name = ‘남**’

II. Gamil 유저중 2020/07/12 ~ 13에 입력된 data 추출하기

  • SELECT * FROM users WHERE email LIKE ‘%gmail.com’ and created_at BETWEEN ‘2020-07-12 00:00:00’ and ‘2020-07-13 23:59:59’

III. Gamil 유저중 2020/07/12 ~ 13에 입력된 data의 Count 하기

  • SELECT COUNT(*) FROM users WHERE email LIKE ‘%gmail.com’ and created_at BETWEEN ‘2020-07-12 00:00:00’ and ‘2020-07-13 23:59:59’

IV. naver eamil 을 사용하면서 웹개발 종합반을 신청하고, 결제는 kakaopay로 이루어진 데이터

  • SELECT * FROM orders WHERE email like ‘%naver.com’ and course_title LIKE ‘웹개발 종합반’ and payment_method LIKE ‘kakaopay’