试试这个 ：
SELECt (AB.agency_no || '-' || AB.branch_no) AS "AGENCY-BRANCH", COUNT(AB.agency_no || '-' || AB.branch_no) AS Occurences, A.AGY_NAME AS AGENCY, SUM(AB.annual_premium) AS PremiumFROM Agency_Book_View AB, Agency A, Branch BWHERe AB.agency_no = A.Agency_No AND AB.branch_no = B.branch_no AND B.EXPIRATION_DATE = TO_DATE('12-31-2078', 'MM-DD-YYYY') AND B.EFFECTIVE_DATE <= SYSDATE AND B.effective_date >= SYSDATE - 364GROUP BY AB.agency_no || '-' || AB.branch_no, A.Agy_NameORDER BY AB.agency_no || '-' || AB.branch_no我加入了B表和AB表，删除了DISTINCT和GROUPED BY ab.annual_premium。
