sql统计接口调用的

SELECT * FROM(SELECT CA.CATALOG_NAME
,CA.CATALOG_CODE
,LOGS1.APPLY_ORG_NAME
,LOGS1.PROVIDE_ORG_NAME
,AP.API_NAME
,AP.API_URL
,AP.API_ID
,SUCCESS
,FALL
,SUM
,RECENT_TIME
,( CASE O.ORG_TYPE WHEN '4' THEN '市直' WHEN '3' THEN '市级' WHEN '5' THEN '县级' WHEN '6' THEN '县直' ELSE '' END ) 
,(SELECT ORG_NAME FROM ORG_ORGANIZATION  OO WHERE AUTH.APPLY_ORG_ID=OO.ORG_ID) APPLY_ORG_NAME2
FROM (SELECT SUM(CASE IS_SUCCESS WHEN 'Y' THEN '1' ELSE '' END) SUCCESS
,(SELECT SUM(CASE IS_SUCCESS WHEN 'N' THEN '1' ELSE '' END)) FALL
,(SELECT COUNT(CALL_LOGS_ID) ) SUM
,(SELECT COUNT(CALL_LOGS_ID) FROM ds_api_call_logs AAA WHERE AAA.CALLED_API_ID= AP.API_ID ) countSUM

,max(API_CALL_TIME) RECENT_TIME
,CALL_LOGS_ID
,CALLED_API_ID,PROVIDE_ORG_ID,APPLY_ORG_ID,APPLY_ORG_NAME,PROVIDE_ORG_NAME,APIKEY FROM ds_api_call_logs CLOG
 inner JOIN DS_API_INFO  AP ON AP.API_ID=CLOG.CALLED_API_ID
GROUP BY APPLY_ORG_ID)  LOGS1
 LEFT JOIN DS_API_INFO  AP ON AP.API_ID=LOGS1.CALLED_API_ID
 LEFT  JOIN
(SELECT   SUM(1) ABC,CALLED_API_ID,CALL_LOGS_ID FROM ds_api_call_logs
GROUP BY CALLED_API_ID) LOGS2 ON AP.API_ID=LOGS2.CALLED_API_ID
 inner JOIN DATA_SERVICE_INFO DS ON AP.SERVICE_ID=DS.SERVICE_ID
  inner JOIN catalog_info CA  ON CA.CATALOG_ID=DS.CATALOG_ID
 LEFT JOIN ORG_ORGANIZATION  O on O.ORG_ID=LOGS1.PROVIDE_ORG_ID
 LEFT JOIN  DS_APPLY_AUTH AUTH ON AUTH.APIKEY=LOGS1.APIKEY)  BB
 INNER JOIN 
 (SELECT 
AP.API_ID
,SUM(SUM) ZZZZZZZZZ
FROM (SELECT SUM(CASE IS_SUCCESS WHEN 'Y' THEN '1' ELSE '' END) SUCCESS

,(SELECT COUNT(CALL_LOGS_ID) ) SUM
,CALLED_API_ID,PROVIDE_ORG_ID,APPLY_ORG_ID,APPLY_ORG_NAME,PROVIDE_ORG_NAME,APIKEY FROM ds_api_call_logs CLOG
 inner JOIN DS_API_INFO  AP ON AP.API_ID=CLOG.CALLED_API_ID
GROUP BY APPLY_ORG_ID)  LOGS1
 inner JOIN DS_API_INFO  AP ON AP.API_ID=LOGS1.CALLED_API_ID
 LEFT  JOIN
(SELECT   SUM(1) ABC,CALLED_API_ID,CALL_LOGS_ID FROM ds_api_call_logs
GROUP BY CALLED_API_ID) LOGS2 ON AP.API_ID=LOGS2.CALLED_API_ID
  GROUP BY API_ID
 ) ZZ
 ON ZZ.API_ID=BB.API_ID