Requeir 6 month AVG for each id

  Hi I need 6 month avg for each Ticket id . i have written below query but did get correct output. Please can me correction . i think i need to use subquery on it but i dont know how . Please sugg...