generate a new report of Survey detail and result

generate a new report of Survey detail and result

Kindly, i need a query to generate a new report of Survey detail and result as following...

Request ID||Request Title||Requester||Technician||Survey||Created Time||Rating Value
Grouped by Category
with providing the surveys count and average for each category and for all the report.

thanks.