+DEFINE{ query_name 'base_mod_req_failure_distribution';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+ comment 'distribution of causes of a modification request failure (base)';
+}
+PARAM{ window uint;}
+select tb, gnb_id as GNB_ID,
+ id_MeNB_UE_X2AP_ID, id_SgNB_UE_X2AP_ID,
+ count(*) as cnt,
+ sum( EQ(failureType,0) ) as count_protobuf_unspecified,
+ sum( EQ(failureType,1) ) as count_t310_Expiry,
+ sum( EQ(failureType,2) ) as count_randomAccessProblem,
+ sum( EQ(failureType,3) ) as count_rlc_MaxNumRetx,
+ sum( EQ(failureType,4) ) as count_synchReconfigFailure_SCG,
+ sum( EQ(failureType,5) ) as count_scg_reconfigFailure,
+ sum( EQ(failureType,6) ) as count_srb3_IntegrityFailure
+From SGNBMODREQ.sgnb_mod_req
+group by timestamp_ms/$window as tb, gnb_id,
+ id_MeNB_UE_X2AP_ID, id_SgNB_UE_X2AP_ID
+;
+