WITH successful_deletesAS (SELECTwb.workspace_id,wb.created_atas delete_time,wb.idas delete_build_idFROM workspace_builds wbJOIN provisioner_jobs pjONwb.job_id=pj.idWHEREwb.transition='delete'ANDpj.completed_atIS NOT NULLANDpj.error ISNULL  )SELECTw.idas workspace_id,u.username||'/'||w.nameas workspace,wb.idas violating_build_id,wb.transitionas violating_transition,wb.created_atas violating_build_time,sd.delete_time,sd.delete_build_id,wb.created_at-sd.delete_timeas time_after_delete,    COALESCE(      string_agg(        DISTINCTwr.name||' ('||wr.type||')',','ORDER BYwr.name||' ('||wr.type||')'      ),'No resources'    )as workspace_resourcesFROM workspace_builds wbJOIN successful_deletes sdONwb.workspace_id=sd.workspace_idJOIN workspaces wONwb.workspace_id=w.idJOIN users uONw.owner_id=u.idLEFT JOIN workspace_resources wrONwb.job_id=wr.job_idANDwr.type NOTLIKE'coder_%'WHEREwb.transitionIN ('start','stop')ANDwb.created_at>sd.delete_timeGROUP BYw.id,w.name,u.username,wb.id,wb.transition,wb.created_at,sd.delete_time,sd.delete_build_idORDER BYwb.created_atDESC;