turbot/hackernews_insights

Query: hackernews_dashboard_user_with_greater_than_5_post

Usage

powerpipe query hackernews_insights.query.hackernews_dashboard_user_with_greater_than_5_post

SQL

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

Params

ArgsNameDefaultDescriptionVariable
$1story_type

    Dashboards

    The query is used in the dashboards: