turbot/hackernews_insights

Query: hackernews_stories_max_comments

Usage

powerpipe query hackernews_insights.query.hackernews_stories_max_comments

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
max(descendants) as "Max Comments"
from
stories

Params

ArgsNameDefaultDescriptionVariable
$1story_type

    Dashboards

    The query is used in the dashboards: