MySQL：having句 #10

#(13)集約結果をさらに絞り込む having句
-- (1)2017 月間ユニークユーザーが630人以上の月
select
  request_month,
  count(distinct user_id)
from
  access_logs
where
  request_month>='2017-01-01' and request_month<'2018-01-01'
group by
  request_month
having
  count(distinct user_id)>=630;

#データの集約　演習問題

select
  request_month,
  count(*)
from
  access_logs
where
  request_month>='2017-01-01'
  and request_month<'2017-07-01'
group by
  request_month
having
  count(*)>1000;

#(13)集約結果をさらに絞り込む having句

-- (1)2017 月間ユニークユーザーが630人以上の月

select

request_month,

count(distinct user_id)

from

access_logs

where

request_month>='2017-01-01' and request_month<'2018-01-01'

group by

request_month

having

count(distinct user_id)>=630;

#データの集約　演習問題

select

request_month,

count(*)

from

access_logs

where

request_month>='2017-01-01'

and request_month<'2017-07-01'

group by

request_month

having

count(*)>1000;

この記事を書いた人
最新の記事

Keita N

最新記事 by Keita N (全て見る)