SQL 1주차

Drumj·2022년 2월 11일
0

SQL 정리

목록 보기
1/5

SELECT * FROM point_users pu
where point > 20000

SELECT * from users u
where name = '황**'

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

SELECT * FROM users u
WHERE name = '황' or name = '이'

SELECT * from orders o
WHERE payment_method !='CARD'

SELECT * from point_users pu
WHERE point BETWEEN 20000 and 23962

SELECT *from users u
where email like 's%com'

SELECT *from users u
where email like 's%com' and name ='이**'

SELECT * from orders o
where payment_method = 'kakaopay'
limit 100

select DISTINCT (payment_method) from orders o

select count(*) from orders
where payment_method ='kakaopay'

select count(DISTINCT(name)) from users u

0개의 댓글