select
from orders
where payment_method = 'kakaopay';
select
from point_users
where point >= 5000;
select
from orders
where course_title = '웹개발 종합반'and payment_method = 'CARD';
select
from point_users
where point > 20000;
select
from users
where name = '황**';
select
from orders o
where course_title = '앱개발 종합반';
select
from orders o
where course_title != '웹개발 종합반';
select
from orders
where created_at
between '2020-07-13' and '2020-07-15';
select
from checkins
where week in (1,3);
select
from users
where email like '%naver.com';
select
from orders
where payment_method != 'CARD';
select
from point_users pu
where point
between 20000 and 30000;
select
from users
where email like 's%com';
select
from users
where email like 's%com' AND name = '이*';
SELECT
FROM orders o
WHERE payment_method = 'kakaopay'
LIMIT 5;
SELECT DISTINCT (payment_method)
FROM orders o ;
select COUNT(*) from users;
