help require in tuning this query

Can someone help me tuning this query,

SELECT DISTINCT S.SITECOUNTRY,S.SITEMNEMONIC,AZ.*

FROM

(SELECT DISTINCT FG.*,

round((FG.PAGE_COMPLTE/FG."EXPECTEDFORM_NEW3")*100,2) AS "% COMPLETE",  --*****--******EXPECTEDFORM NEW3 IS USE..WE SHOULD USE THIS ONE..

(CASE WHEN /*  FG.SDVCOMPLETESTATE=0 AND   */FG.PAGE_COMPLTE=0 THEN 0 ELSE round((FG.SDVCOMPLETESTATE/FG.PAGE_COMPLTE)*100,2) END) AS "% SDV Complete to Completed",

round((FG.SDVCOMPLETESTATE/FG."EXPECTEDFORM_NEW3")*100,2) AS "% SDV Complete to Expected",

round((FG.SDVCOMPLETESTATE/FG.HASSDVREQUIREDITEMS)*100,2) AS "% SDV Complete",

(CASE WHEN /*  FG.FROZENSTATE=0 AND   */FG.PAGE_COMPLTE=0 THEN 0 ELSE round((FG.FROZENSTATE/FG.PAGE_COMPLTE)*100,2) END) AS "% FROZENSTATE",

(CASE WHEN /*  FG.LOCKEDSTATE=0 AND   */FG.PAGE_COMPLTE=0 THEN 0 ELSE round((FG.LOCKEDSTATE/FG.PAGE_COMPLTE)*100,2) END) AS "% LOCKEDSTATE"