Help with custom query

I need to create a report that shows timestamp, hostname, category, and browse time for a given time range for a given user. I need to tailor it so that it reduces the frequency of the line items- current reports list up to ten websites during a given second, and this is cumbersome to pore through. How can I create the dataset for the above fields that will only report twice per minute, rather than 30-100 times a minute? Would each line have to be a mini-report that summarizes the previous minute of traffic? I speak MSSQL, not PostGRE, but am willing to learn- Please help!