I have written a query like
Select case when c.statecode=0 then c.createdon else c.resolvedon,ad.name from incident as a
Left join systemuser as ac on c.owininguser=ac.systwmuserid
Left join team membership on ac.systemuserid=teammembership.systemuserid
Left join team as ad on team membership.teamid=ad teamid
Where c.createon>=dateadd(day,-7,getdate())
And ad.name='abc'
Group by createon,ad.team,resolvedon
