Rolling Time Window with Distinct Count in Big SQL using DENSE_RANK() Function

Workaround SQLSTATE 58004: Error 'Invalid QNC Assignment' when using NULL in JSON_OBJECT() with LISTAGG in DB2 LUW