I have a use case where I want to calculate the number of dates which had stocks in and out. My tbl schema has just 4 cols : stock_type, in_date, out_date, serial_no.
| stck_typ | in_date | out_date | serial_no |
|---|---|---|---|
| S1 | 2022-11-10 | 2022-11-18 | 103 |
| S3 | 2022-11-13 | 2022-11-25 | 104 |
| S2 | 2022-12-01 | 2022-12-07 | 102 |
tbl structure:
