teradata

I have this table (table_2), which basically provides patient info and the department they visited on specific dates – Patient_ID department service_dte birth_dte count 12345 cardiac 1/2/21 6/18/78 5 12345 cardiac 8/20/21 6/18/78 5 12345 cardiac 10/28/21 6/18/78 5 12345 ortho 1/14/21 6/18/78 2 12345 ortho 7/7/21 6/18/78 2 12345 […]