Help with custom report

Hello! I have a report that calculates the total amount of traffic. Please help correct the SQL query so that the report displays the total time that the user spent viewing the site, allowed sessions, blocked sessions and amount of sessions. Total traffic, total time, allowed sessions, blocked sessions and amount of sessions should be displayed in one report. And it would be great to see in the report amount of requests to the site.

Is it possible to limit the sampling of data by the hour in a fortianalyzer? For example, I need data for the last 7 days, but in the period from 8 to 19:00. My query: select domain, string_agg(distinct catdesc, ', ') as agg_catdesc, user_src, sum(bandwidth) as bandwidth, sum(traffic_in) as traffic_in, sum(traffic_out) as traffic_out from ###(select coalesce(nullifna(hostname), ipstr(`dstip`)) as domain, catdesc, coalesce(nullifna(`user`), nullifna(`unauthuser`), ipstr(`srcip`)) as user_src, sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0)) as bandwidth, sum(coalesce(rcvdbyte, 0)) as traffic_in, sum(coalesce(sentbyte, 0)) as traffic_out from $log-traffic where $filter and (logflag&1>0) and utmaction!='blocked' and (countweb>0 or ((logver is null or logver<52) and (hostname is not null or utmevent in ('webfilter', 'banned-word', 'web-content', 'command-block', 'script-filter')))) group by domain, catdesc, user_src having sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0))>0 /*SkipSTART*/order by bandwidth desc/*SkipEND*/)### t group by domain, catdesc, user_src order by bandwidth desc