mysql에서 평균으로 조건 처리 가능할까요 ?

mysql에서 평균으로 조건 처리 가능할까요 ? 채택완료

KIMys 11년 전 조회 7,101

SELECT count(*) as cnt, IFNULL(SUM(mb_16+mb_17+mb_18+mb_19),0) as sum, avg((mb_16+mb_17+mb_18+mb_19)/4) as avg FROM `g4_member` WHERE mb_jumin = '1' GROUP BY mb_id ORDER BY mb_id asc

이렇게 하면

아래 처럼 값이 나오는데 여기서 평균값이 4이상인 것만 처리하려고 합니다.

어떻게 처리할 수 있나요 ?

http://ruwa64-044.fmcity.com/WebMysql/sql.php?db=rok708_cherrypet&table=g4_member&token=e75e6ba6bf774c4e0f70787be1bcb418&sql_query=SELECT%0Acount%28%2A%29+as+cnt%2C%0AIFNULL%28SUM%28mb_16%2Bmb_17%2Bmb_18%2Bmb_19%29%2C0%29+as+sum%2C%0Aavg%28%28mb_16%2Bmb_17%2Bmb_18%2Bmb_19%29%2F4%29+as+avg%0AFROM+%60g4_member%60+%0AWHERE+mb_jumin+%3D+%271%27%0AGROUP+BY+mb_id%0A+ORDER+BY+%60cnt%60+ASC" target="_blank">cnt	http://ruwa64-044.fmcity.com/WebMysql/sql.php?db=rok708_cherrypet&table=g4_member&token=e75e6ba6bf774c4e0f70787be1bcb418&sql_query=SELECT%0Acount%28%2A%29+as+cnt%2C%0AIFNULL%28SUM%28mb_16%2Bmb_17%2Bmb_18%2Bmb_19%29%2C0%29+as+sum%2C%0Aavg%28%28mb_16%2Bmb_17%2Bmb_18%2Bmb_19%29%2F4%29+as+avg%0AFROM+%60g4_member%60+%0AWHERE+mb_jumin+%3D+%271%27%0AGROUP+BY+mb_id%0A+ORDER+BY+%60sum%60+ASC" target="_blank">sum	http://ruwa64-044.fmcity.com/WebMysql/sql.php?db=rok708_cherrypet&table=g4_member&token=e75e6ba6bf774c4e0f70787be1bcb418&sql_query=SELECT%0Acount%28%2A%29+as+cnt%2C%0AIFNULL%28SUM%28mb_16%2Bmb_17%2Bmb_18%2Bmb_19%29%2C0%29+as+sum%2C%0Aavg%28%28mb_16%2Bmb_17%2Bmb_18%2Bmb_19%29%2F4%29+as+avg%0AFROM+%60g4_member%60+%0AWHERE+mb_jumin+%3D+%271%27%0AGROUP+BY+mb_id%0A+ORDER+BY+%60avg%60+ASC" target="_blank">avg
1	18	4.5
1	0	0
1	13	3.25
1	11	2.75

mysql에서 평균으로 조건 처리 가능할까요 ? 채택완료

답변 1개

답변에 대한 댓글 1개

mysql에서 평균으로 조건 처리 가능할까요 ? 채택완료

답변 1개

답변에 대한 댓글 1개

공유하기