Query: hackernews_stories_avg_comments

Usage

powerpipe query hackernews_insights.query.hackernews_stories_avg_comments

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
  round(avg(descendants), 1) as "Avg Comments"
from
  hackernews_new

Params

Args	Name	Default	Description	Variable
$1	story_type

Dashboards

The query is used in the dashboards:

Hacker News Stories