Need to modify Query reports

Hi there, need some reports:

1. avg time to solve a request where tech group = "group 1 and group2"

I've got this query, could you modify it?

SELECT MAX(pd.PRIORITYNAME) "Priority", TO_CHAR(((AVG(wo.TIMESPENTONREQ))/1000 || ' second')::interval, 'HH24:MI:SS') "AVG Time Elapsed", TO_CHAR(((SUM(wo.TIMESPENTONREQ))/1000 || ' second')::interval, 'HH24:MI:SS') "Total Time Elapsed" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID WHERE (wo.ISPARENT='1') AND wo.completedtime>= <from_lastmonth> AND wo.completedtime<= <to_lastmonth> GROUP BY pd.PRIORITYID

2. top 10 requesters where tech group = "group 1 and group2"

I've got this query, could you modify it?

SELECT MAX(aau.FIRST_NAME) "Requester",COUNT(wo.WORKORDERID) "Request Count" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID WHERE (wo.ISPARENT='1') and wo.CREATEDTIME >= <from_lastmonth> AND wo.CREATEDTIME <= <to_lastmonth> GROUP BY wo.REQUESTERID ORDER BY 2 desc limit 10

3. tech assign in minutes where tech group = "group 1 and group2"

I've got this query, could you modify it?

SELECT wo.WORKORDERID "Request ID",MAX(aau.FIRST_NAME) "Requester",MAX(qd.QUEUENAME) "Group",MAX(ti.FIRST_NAME) "Technician",MAX(wo.TITLE) "Subject",MAX(pd.PRIORITYNAME) "Priority", LONGTODATE(MAX(wo.CREATEDTIME)) "Created Time",LONGTODATE(MAX(wo.DUEBYTIME)) "DueBy Time",MAX(std.STATUSNAME) "Request Status", (SELECT to_timestamp(MIN(woh2.OperationTime)/1000)::TIMESTAMP from workorderhistory woh2 LEFT JOIN WorkOrderHistorydiff wohd2 ON woh2.HISTORYID=wohd2.HISTORYID where woh2.operation in ('Update', 'Assign') and wohd2.COLUMNNAME='OwnerID' AND wohd2.prev_value is NULL AND woh2.WORKORDERID=wo.WORKORDERID) "Tech Assigned",
((SELECT MIN(woh2.OperationTime) from workorderhistory woh2 LEFT JOIN WorkOrderHistorydiff wohd2 ON woh2.HISTORYID=wohd2.HISTORYID where woh2.operation in ('Update', 'Assign') and wohd2.COLUMNNAME='OwnerID' AND wohd2.prev_value is NULL AND woh2.WORKORDERID=wo.WORKORDERID) - max(wo.createdtime))/1000/60 "to assign in Minutes" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID WHERE (wo.ISPARENT='1') AND wo.CREATEDTIME >= <from_lastmonth> AND wo.CREATEDTIME <= <to_lastmonth> GROUP BY wo.WORKORDERID
order by 1