스파르타코딩클럽
[왕초보] 엑셀보다 쉬운, SQL 2주차 개발일지
select * from users ---- 1
group by name ---- 2
select name, count(*) from users ---- 3
group by name
select week, avg(like) from checkins
group by week
select week, round(avg(like), 2) from checkins
group by week
select name, count(*) from users
group by week
order by count(*) desc (내림차순으로 정렬, 기본은 오름차순)
select payment_method, count(*) from orders
where course_title = '웹개발 종합반'
group by payment_method
order by count(*) desc
select * from users
order by name
select * from orders o
where o.course_title = '앱개발 종합반'
select payment_method, count(*) as cnt from orders o
group by payment_method