hi, i have the table you can see attached, it has this structure
ID Nome Cognome Data_nascita DENOMINAZIONE_SOGGETTO_ABILITATO data_inizio Data_fine NoCambio Data/ora creazione Data/ora modifica Comune 260195 name surname 19/08/1972 BANCA WISE DIALOG BANK SPA-BANCA WIDIBA
20/06/2022 No 20/06/2022 18:23:15
260195 name surname 19/08/1972 BANCA WISE DIALOG BANK SPA - BANCA WIDIBA 20/06/2022
No 20/06/2022 18:23:16
260201 name surname 29/09/1974 FINECOBANK BANCA FINECO SPA
20/06/2022 No 20/06/2022 18:23:15
260201 name surname 29/09/1974 FINECOBANK BANCA FINECO S.P.A. 20/06/2022
No 20/06/2022 18:23:16
260204 name surname 10/01/1979 BANCA GENERALI SPA
24/09/2022 No 31/08/2022 20:20:33
260204 name surname 10/01/1979 \N 31/08/2022 24/09/2022 No 31/08/2022 20:20:34
260204 name surname 10/01/1979 BANCA NAZIONALE DEL LAVORO S.P.A. 24/09/2022
No 24/09/2022 19:36:56
260210 name surname 15/02/1979 FIDEURAM-INTESA SANPAOLO PRIVATE BANKING SPA IN FORMA ABBREVIATA FIDEURAM SPA
20/06/2022 No 20/06/2022 18:23:15
260210 name surname 15/02/1979 FIDEURAM - INTESA SANPAOLO PRIVATE BANKING SPA IN FORMA ABBREVIATA FIDEURAM SPA 20/06/2022
No 20/06/2022 18:23:16
260221 name surname 28/04/1977 \N
18/07/2022 No 18/07/2022 18:40:04
260221 name surname 28/04/1977 INTESA SANPAOLO SPA 18/07/2022
No 18/07/2022 18:40:04
260224 name surname 14/06/1974 FIDEURAM-INTESA SANPAOLO PRIVATE BANKING SPA IN FORMA ABBREVIATA FIDEURAM SPA
20/06/2022 No 20/06/2022 18:23:15
260224 name surname 14/06/1974 FIDEURAM - INTESA SANPAOLO PRIVATE BANKING SPA IN FORMA ABBREVIATA FIDEURAM SPA 20/06/2022
No 20/06/2022 18:23:16
260241 name surname 27/06/1977 VALORI & FINANZA INVESTIMENTI SIM S.P.A.
20/06/2022 No 20/06/2022 18:23:15
260241 name surname 27/06/1977 VALORI & FINANZA INVESTIMENTI SIM SPA 20/06/2022
No 20/06/2022 18:23:16
260242 name surname 27/11/1960 BANCA WISE DIALOG BANK SPA-BANCA WIDIBA
20/06/2022 No 20/06/2022 18:23:15
260242 name surname 27/11/1960 BANCA WISE DIALOG BANK SPA - BANCA WIDIBA 20/06/2022
No 20/06/2022 18:23:16
260243 name surname 20/02/1950 FIDEURAM-INTESA SANPAOLO PRIVATE BANKING SPA IN FORMA ABBREVIATA FIDEURAM SPA
20/06/2022 No 20/06/2022 18:23:15
260243 name surname 20/02/1950 FIDEURAM - INTESA SANPAOLO PRIVATE BANKING SPA IN FORMA ABBREVIATA FIDEURAM SPA 20/06/2022
No 20/06/2022 18:23:16
260244 name surname 24/10/1970 BANCA NAZIONALE DEL LAVORO S.P.A.
24/09/2022 No 24/09/2022 19:36:56
PESCARA 260244 name surname 24/10/1970 \N 24/09/2022
No 24/09/2022 19:36:56
260248 name surname 22/03/1986 BANCA MEDIOLANUM SPA 04/11/2021
No 27/06/2022 16:30:42
260250 name surname 12/04/1956 IW PRIVATE INVESTMENTS SIM SPA
20/06/2022 No 20/06/2022 18:23:15
260250 name surname 12/04/1956 IW PRIVATE INVESTMENTS SIM S.P.A 20/06/2022
No 20/06/2022 18:23:16
260257 name surname 07/06/1956 FINECOBANK BANCA FINECO SPA
20/06/2022 No 20/06/2022 18:23:15
260257 name surname 07/06/1956 FINECOBANK BANCA FINECO S.P.A. 20/06/2022
No 20/06/2022 18:23:16
260263 name surname 03/02/1960 FINECOBANK BANCA FINECO SPA
20/06/2022 No 20/06/2022 18:23:15
i'd like to know the trend of every bank year per year making a chart, so for example i'll count how many people started (data_inizio means "start date") working in "BANCA MEDIOLANUM SPA" in a year and then i subtract the number of people quit (data_fine means "end date") working with same bank in that year
then i'd ike to make a chart