Query: hackernews_dashboard_user_with_greater_than_5_post

with data as (
  (select
  by,
  count(*) as posts
  from
    hackernews_new where $1 = 'New' and by is not null
  group by
    by
  order by
    posts desc)
  union
  (select
    by,
  count(*) as posts
  from
    hackernews_top where $1 = 'Top' and by is not null
  group by
    by
  order by
    posts desc)
  union
  (select
    by,
  count(*) as posts
  from
    hackernews_best where $1 = 'Best' and by is not null
  group by
    by
  order by
    posts desc)
)
select
  *
from
  data
where
  posts > 5
limit
  25