[SQL] 1주차 개발일지

 

select * from point_users

where point > 20000

select * from users
WHERE name = ‘황**’

SELECT * from orders
where course_title = ‘웹개발 종합반’ and payment_method = ‘CARD’

 

 

1-7 퀴즈
SELECT * from orders
where payment_method != ‘CARD’SELECT * from point_users
WHERE point BETWEEN 20000 and 30000SELECT * from users
WHERE email like ‘s%com’SELECT * from users
WHERE email LIKE ‘s%com’ and name = ‘이**’

 

1-9 퀴즈
SELECT name,email from users
WHERE name = ‘남**’SELECT * from users
where email like ‘%@gmail.com’
and created_at BETWEEN ‘2020-07-12’ and ‘2020-07-14’SELECT count(user_id) from users
where email like ‘%@gmail.com’
and created_at BETWEEN ‘2020-07-12’ and ‘2020-07-14’

 

1주차 숙제

SELECT * from orders

where email like '%@naver.com'

and course_title = '웹개발 종합반'

and payment_method = 'kakaopay'

 

-------

알아둬야 할 것

* : 전체를 의미함

like + % : ~앞의 내용은 상관없음을 의미함

^ + enter : 결과 도출