select

tx_hash,

block_timestamp,

signer_id,

node,

parse_json(node_data:comment) as jsona_comment,

parse_json(node_data:comment):item:path as jsona_item_path

from near.social.fact_decoded_actions

join near.core.fact_transactions using(tx_hash)

where tx_status = 'Success'

and node = 'post'

and jsona_comment is not null

and jsona_item_path is not null

select

count(distinct tx_hash) as "Total Number of Comments",

count(distinct signer_id) as "Total Number of Accounts"

from add_comment_list