목록SQLite (1)
Data Blog
[SQL] solvesql beta 연습 문제 풀이
모든 데이터 조회하기 select * from points 일부 데이터 조회하기 select * from points where quartet = "I" 데이터 정렬하기 select * from points where 1 = 1 and quartet = "I" order by y 데이터 그룹으로 묶기 select quartet, round(avg(x),2) as x_mean, round(variance(x),2) as x_var, round(avg(y),2) as y_mean, round(variance(y),2) as y_var from points where 1 = 1 group by quartet 두 테이블 결합하기 SELECT r.ATHLETE_ID FROM RECORDS r left join E..
SQL/solvesql
2023. 1. 31. 13:07