inblog logo
|
silver
    SQL문제풀기

    [SQL문제풀기] 데이터 그룹으로 묶기

    silver's avatar
    silver
    Aug 11, 2025
    [SQL문제풀기] 데이터 그룹으로 묶기
    Contents
    문제SQLite

    문제

    solvesql.com
    solvesql.com
    https://solvesql.com/problems/group-by/

    SQLite

    내가 작성한 정답

    select quartet, round(avg(x),2) x_mean, round(var_samp(x),2) x_var, round(avg(y),2) y_mean, round(var_samp(y),2) y_var from points group by quartet
    💡
    DBMS
    표본 분산 함수
    PostgreSQL
    VAR_SAMP()
    MySQL
    VAR_SAMP()
    Oracle
    VAR_SAMP()
    SQL Server
    VAR() 또는 VARP()
    SQLite
    VAR_SAMP()
    Share article

    silver

    RSS·Powered by Inblog