Explore: Docket Comment Stats

Comment statistics for a docket grouped by submitter type.

Custom SQL query (hide) 

SELECT submitter_type, COUNT(*) AS comment_count, MIN(posted_date) AS first_comment, MAX(posted_date) AS last_comment FROM comments WHERE docket_id = :docket_id GROUP BY submitter_type ORDER BY comment_count DESC

Query parameters

Edit SQL

0 results