sqlÓï¾äµÄÓÅ»¯

SELECT    a.number * 100 / b.number AS ±ÈÀý
from  (SELECT    COUNT(*) AS number from    EC_ROLE  WHERE      (GRADE >= 25) AND (GRADE <= 30) AND (SCHOOL = '0¡¯)AND (ID IN  (SELECT    t1.ROLE_ID  from          EC_ROLE_TASK AS t1 INNER JOIN  EC_TASK AS t2 ON t1.TASK_ID = t2.ID
WHERE      (t2.GRADE >= 15) AND (t2.GRADE <= 20) AND (t1.TASK_STATE = '3')))) AS a ,
(SELECT    COUNT(*) AS number  from          EC_ROLE AS EC_ROLE_1 WHERE      (GRADE >= 25) AND (GRADE <= 30) AND (SCHOOL = ' 0')) AS b

---

Ö±½ÓÀ´±í½á¹¹£¬²âÊÔÊý¾ÝºÍÄãÒªµÄ½á¹û°É£¬²¢ËµËµÄãµÄËã·¨

---

ÒýÓÃ

Ö±½ÓÀ´±í½á¹¹£¬²âÊÔÊý¾ÝºÍÄãÒªµÄ½á¹û°É£¬²¢ËµËµÄãµÄËã·¨

ºÃµÄ£¬µÈϹþ

---

---

ÒýÓÃ

Ö±½ÓÀ´±í½á¹¹£¬²âÊÔÊý¾ÝºÍÄãÒªµÄ½á¹û°É£¬²¢ËµËµÄãµÄËã·¨

µÚÒ»ÕűíΪec_role£¨½ÇÉ«±í£©×Ö¶ÎÈçÏÂ
id  name£¨ÐÕÃû£© sex£¨ÐԱ𣩠grade£¨½ÇÉ«µÈ¼¶µÈ¼¶£©  school(°ïÅÉ)

µÚ¶þÕűíΪec_task£¨ÈÎÎñ±í£© ×Ö¶ÎÈçÏÂ

id  title£¨ÈÎÎñÃû³Æ£© grade£¨ÈÎÎñµÈ¼¶£©

µÚÈýÕűíΪec_role_task(½ÇÉ«ÈÎÎñ±í) ×Ö¶ÎÈçÏÂ
  role_id  task_id  task_state(״̬)  ÆäÖÐ0±íʾδÍê³É 3±íʾÍê³É
ÇóÍê³É15-20¼¶ËùÓÐÈÎÎñµÄ25-30¼¶½Ç