Need A Report

Hi All, I need a report designed. When I run the following code:

SELECT "cd"."CATEGORYNAME" AS "Category", "wo"."WORKORDERID" AS "Request ID", "wo"."CREATEDTIME" AS "Created Time" FROM "WorkOrder" "wo" LEFT JOIN "WorkOrderStates" "wos" ON "wo"."WORKORDERID"="wos"."WORKORDERID" LEFT JOIN "CategoryDefinition" "cd" ON "wos"."CATEGORYID"="cd"."CATEGORYID" LEFT JOIN "WorkOrder_Queue" "woq" ON "wo"."WORKORDERID"="woq"."WORKORDERID" LEFT JOIN "QueueDefinition" "qd" ON "woq"."QUEUEID"="qd"."QUEUEID" WHERE ( ( "qd"."QUEUENAME" = N'Technology Services' ) AND ( ( ( "wo"."CREATEDTIME" >= datetolong('2020-03-31') ) AND ( ( "wo"."CREATEDTIME" != 0 ) AND ( "wo"."CREATEDTIME" IS NOT NULL ) ) ) AND ( ( "wo"."CREATEDTIME" <= 1586354399000 ) AND ( ( ( "wo"."CREATEDTIME" != 0 ) AND ( "wo"."CREATEDTIME" IS NOT NULL ) ) AND ( "wo"."CREATEDTIME" != -1 ) ) ) ) ) AND wo.ISPARENT='1' ORDER BY 3

I get the following output

Current Output

Required Output

Column should group by week, i.e. if my date filter is between 2020-03-31 to 2020-04-08, the report should be able to group by week as per example below