SELECT
CONVERT(DATE, created) as date,
COUNT(author)

FROM comments
WHERE
CONVERT(DATE,created) BETWEEN '2023-05-01' AND '2023-05-23'
AND ISJSON(comments.json_metadata) = 1
AND JSON_VALUE(comments.json_metadata, '$.app') LIKE 'leothreads/0.3%'
AND depth != 0
--AND parent_author = 'leothreads'
AND root_title LIKE 'LeoThread%'

GROUP BY CONVERT(DATE, created)
ORDER BY CONVERT(DATE, created) asc