Number Non-Null Values in Order within the Group — From SQL to SPL #17

Problem description & analysis: After sorting a table in the Oracle database according to the first and second columns, the third column has non-null values. Task: Now we need to add a calculated column RN_C1: within a group of data with the same CP...