comment command for confluence

select a.creationdate,a.lastmoddate,b.username from content a ,user_mapping b where a.contenttype='COMMENT' and a.creator=b.user_key and a.creationdate between '2015/9/30' and '2015/10/1'

select count(*),b.username from content a ,user_mapping b where a.contenttype='COMMENT' and a.creator=b.user_key and a.creationdate between '2015/9/30' and '2015/10/1' group by b.username