group by \ub294 \uadf8\ub8f9\uc5d0 \ub300\ud55c \ubd80\ubd84\ud569\uacc4\ub97c \ubcfc\uc218 \uc788\ub2e4. \ud558\uc9c0\ub9cc \uc0c1\uc138\ub0b4\uc5ed\uc744 \ubcfc\uc218\ub294 \uc5c6\ub2e4. \uc0c1\uc138\ub0b4\uc5ed\uacfc \uadf8\ub8f9\ud569\uacc4\ub97c \ubaa8\ub450 \ud55c\uaebc\ubc88\uc5d0 \ubcfc\uc218\ub294 \uc5c6\uc744\uae4c..
\n\uadf8\uac8c \ubc14\ub85c compute\uc640 compute by \ubb38\uc774\ub2e4.<\/p>\n
\uc804\uccb4 \ud3c9\uade0\uacfc \uadf8\ub8f9\ubcc4 \ud3c9\uade0\uc744 \uad6c\ud574\ubcf4\uc790<\/p>\n
select avg(price) from titles : \uc804\uccb4\ud3c9\uade0<\/p>\n
select type, avg(price)
\nfrom titles
\ngroup by type : \uadf8\ub8f9\ubcc4 \ud3c9\uade0<\/p>\n
\uacb0\uacfc
\ntype
\n———— ———————
\nbusiness 8.9825
\nmod_cook 11.4900
\npopular_comp 21.4750
\npsychology 13.5040
\ntrad_cook 15.9633
\nUNDECIDED NULL<\/p>\n
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++<\/p>\n
compute\ub97c \uc4f0\uba74<\/p>\n
select type, title_id, price
\nfrom titles
\norder by type
\ncompute avg(price) by type<\/p>\n
\uacb0\uacfc\uac12
\ntype title_id price
\n———— ——– ———————
\nbusiness BU1032 1.0000
\nbusiness BU1111 11.9500
\nbusiness BU2075 2.9900
\nbusiness BU7832 19.9900<\/p>\n
avg
\n =====================
\n 8.9825<\/p>\n
type title_id price
\n———— ——– ———————
\nmod_cook MC2222 19.9900
\nmod_cook MC3021 2.9900<\/p>\n
avg
\n =====================
\n 11.4900<\/p>\n
\uc804\uccb4 \ud3c9\uade0\uc740 compute\ub9cc \uc4f4\ub2e4<\/p>\n
select type, title_id, price
\nfrom titles
\ncompute avg(price) <\/p>\n
\uacb0\uacfc\uac12
\ntype title_id price
\n———— ——– ———————
\nbusiness BU1032 1.0000
\nbusiness BU1111 11.9500
\nbusiness BU2075 2.9900
\nbusiness BU7832 19.9900
\nmod_cook MC2222 19.9900
\nmod_cook MC3021 2.9900
\nUNDECIDED MC3026 NULL
\npopular_comp PC1035 22.9500
\npopular_comp PC8888 20.0000
\npopular_comp PC9999 NULL
\npsychology PS1372 21.5900
\npsychology PS2091 10.9500
\npsychology PS2106 7.0000
\npsychology PS3333 19.9900
\npsychology PS7777 7.9900
\ntrad_cook TC3218 20.9500
\ntrad_cook TC4203 11.9500
\ntrad_cook TC7777 14.9900<\/p>\n
avg
\n =====================
\n 13.5793<\/p>\n","protected":false},"excerpt":{"rendered":"
group by \ub294 \uadf8\ub8f9\uc5d0 \ub300\ud55c \ubd80\ubd84\ud569\uacc4\ub97c \ubcfc\uc218 \uc788\ub2e4. \ud558\uc9c0\ub9cc \uc0c1\uc138\ub0b4\uc5ed\uc744 \ubcfc\uc218\ub294 \uc5c6\ub2e4. \uc0c1\uc138\ub0b4\uc5ed\uacfc \uadf8\ub8f9\ud569\uacc4\ub97c \ubaa8\ub450 \ud55c\uaebc\ubc88\uc5d0 \ubcfc\uc218\ub294 \uc5c6\uc744\uae4c.. \uadf8\uac8c \ubc14\ub85c compute\uc640 compute by \ubb38\uc774\ub2e4. \uc804\uccb4 \ud3c9\uade0\uacfc \uadf8\ub8f9\ubcc4 \ud3c9\uade0\uc744 \uad6c\ud574\ubcf4\uc790 select avg(price) from titles : \uc804\uccb4\ud3c9\uade0 select type, avg(price) from titles group by type : \uadf8\ub8f9\ubcc4 \ud3c9\uade0 \uacb0\uacfc type ———— ——————— business 8.9825 mod_cook 11.4900 popular_comp … \uacc4\uc18d \uc77d\uae30 “COMPUTE \uc640 COMPUTE BY \uc4f0\uae30”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1411","post","type-post","status-publish","format-standard","hentry","category-tip"],"_links":{"self":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1411","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1411"}],"version-history":[{"count":0,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1411\/revisions"}],"wp:attachment":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1411"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1411"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}