Finding difference in dates , group by another column

[sriniprad08]

Hi Team,

I have situation where we have to difference between two dates group by id column. The results should be another column interms of dates,

The questions are 1) and 2)

Please let me know your thoughts.

id	start date	end date
3663	12/13/2002	12/30/2021
3663	1/15/2003	12/20/2002
1234	4/8/2003	12/31/2003
1234	7/2/2003	12/31/2020
1234	8/6/2003	9/30/2003
3663	8/6/2003	9/30/2004
2143	8/6/2003	1/30/2004
2142	8/6/2003	2/27/2004

Thanks,

Sriniv

[Qiu]

@sriniprad08 
Always happy to be any assist.
@atcodedog05 
You are the best😁