[스파르타/SQL] Select ~ from / Where

< 엑셀보다 쉬운, SQL 1주차 >

외워야 할 기본적인 코딩

문자열은 작은 따옴표
실행 Ctrl + Enter

#select 필드(*는 전체) from 테이블
#숫자세기 count / 중복제거 distinct 
select count(distinct(A)) from B

#조건
Where
	#C필드에서 D 가져오기 ''는 문자열, 숫자는 그냥 입력
	C = 'D'
	
    #E필드에서 F 아닌 것 가져오기
and E != 'F'

	#G필드에서 H보다 작은 것 가져오기
and G > H

	#I필드에서 J보다 크고 K보다 작은 것 가져오기. 범위
    #J K 포함됨. 2023-07-05 and 07-07 = ~7일 00:00:00
and I Between J and K

	#L필드에서 M과 N 가져오기. 범위 아님
and L in(M, N) 

	#O필드에서 P로 끝나는 문자열 가져오기. 'P%', '%P%'
and O like '%P'

화이팅 :)

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
where course_title = '웹개발 종합반' and payment_method = 'card'


select * from orders
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 '%daum.net'


select * from orders
where payment_method != 'card'

select * from point_users
where point between 20000 and 30000

select * from users
where email like 's%com'

select * from users
where email like 's%com' and name = '이**' #name like '이%'

select * from orders
where payment_method = 'kakaopay'
limit 5

select distinct(payment_method) from orders

select count(*) from orders

select count(distinct(name)) from users

#9 퀴즈 뚜둥
select 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(*) 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'