Untitled

SELECT COUNT(*) FROM tibtcare_ppm_st2.RMS_USAGE_TYPE_MST_AUD WHERE (UTM_CODE, op_id, bu_id) IN (SELECT entity_idusgcmp.UTM_CODE,op_idusgcmp.op_id,bu_idusgcmp.bu_id FROM tibtcare_ppm_st2.release_entity_inst_map WHERE release_id='1.0' AND op_id='HOB' AND bu_id='DEFAULT')