counting changed month to month from the same table

Hello !

Below is an example of the data structure I am working with, I have also included the below in an excel sheet as an attachment.

ID Open/Closed RAG_Score Month
1 Open 2 Jan-22
2 Open 3 Jan-22
3 Open 4 Jan-22
4 Open 5 Jan-22
1 Closed 2 Feb-22
2 Open 3 Feb-22
3 Open 4 Feb-22
4 Open 7 Feb-22
5 Open 10 Feb-22
1 Closed 2 Mar-22
2 Open 4 Mar-22
3 Closed 4 Mar-22
4 Open 7 Mar-22
5 Open 10 Mar-22
6 Open 5 Mar-22


Each month I am going to drop the new month data into the table. I want to an automated way to:

-Evaluate the number of new ID's that have appeared.
-How many RAG_SCORES have Increased/Decreased/Stayed the same.
-A break down of how many long ID's have been present i.e. 100 have been present for 2 months, 300 have been present for 3 months.......
-A piece on how long ID's have been present and the number of RAG_SCORE changes.

Any help would be greatly appreciated

Many thanks.