select * from (
select f1,f2,t from table where date > sysdate - 2
)
pivot xml (
count(t) as al, sum(t) as ev
for f2 in (any)
)

##</code><code>##

f1
--
f2_xml
--------------------------------------------
99999
<PivotSet><item><column name = "F2">0</column><column name = "AL">12</c
olumn><column name = "EV">169</column></item></PivotSet>

##</code><code>##

varnn = {
    'f1' = '99999'.
    'f2_xml' = []
    };