Query: hackernews_dashboard_user_with_greater_than_50_score

Usage

powerpipe query hackernews_insights.query.hackernews_dashboard_user_with_greater_than_50_score

Steampipe Tables

hackernews_best

hackernews_new

hackernews_top

SQL

with stories as (
  select
    *
  from
    hackernews_new
  where
    $1 = 'New'
  union
  select
    *
  from
    hackernews_top
  where
    $1 = 'Top'
  union
  select
    *
  from
    hackernews_best
  where
    $1 = 'Best'
)
select
  by,
  max(score) as max_score
from
  stories
where
  score > 50
group by
  by
order by
  max_score desc
limit
  25

Params

Args	Name	Default	Description	Variable
$1	story_type

Dashboards

The query is used in the dashboards:

Hacker News Dashboard