string countQuery = @"SELECT TRAINING_PLAN_TRAINEEID, count(*)  from TABLE_TRAINING_PLAN  WHERE 
                     TRAINING_PLAN_TRAINEEID IN (SELECT 
                    GRP_EMPLOYEE_USERID  FROM  TABLE_GRP_EMPLOYEE WHERE  GRP_EMPLOYEE_SITEID  =@siteId and 
                    GRP_EMPLOYEE_ISACTIVE =1) and 
                     TRAINING_PLAN_STATUS =2 and
  TRAINING_PLAN_ISACTIVE  =1 group by 
                    TRAINING_PLAN_TRAINEEID;"
      using (SqlCommand cmd = new SqlCommand(countQuery, conn))
       {
         cmd.Parameters.AddWithValue("@siteId", whereArgs[0]);
         using (SqlDataReader reader = cmd.ExecuteReader())
         {
             // process the results
         }
       }