select alias,scheme_family,date_r,initcap(date_r) as showdate_r,iriscode,fund_code,nvl(sum(mkt_value),-99999) mkt,nvl(sum(mkt_value)/total_assets*100,-99999) persum,count(iriscode) cnn from zmf_new_comp_srch where ( (upper(irissector) = 'CEMENT')) and total_assets > 0 group by alias,scheme_family,iriscode,fund_code,total_assets,date_r order by ALIAS,SCHEME_FAMILY asc