Cognos SQL, unable to convert to Native SQL

[cognosun]

Gurus,

Can anyone help me how to convert (roughly) this Cognos SQL to Oracle SQL, which is written for one derived column.

SUM(MAX(COLUMN A for COLUMN  B) at COLUMN B) / COUNT ( COLUMN B at COLUMN B)
-------------

I need native SQL for the same, but with above expression, it's splitting Column B as seperate column, and sum() function is taking away decimals from the output.

Many Thanks in Advance
Joys

[Invisi]

I don't know where you get this Cognos SQL from, but doesn't Cognos allow you to see the actual SQL sent to the database in Report Studio? Use that option?