example:

select * from vw_teste

pivot (AVG(ocorrencias) for metodoctb IN ([tipo 1],[TIPO 2],[TIPO 5],[TIPO 7])) as teste

this has average.

I don't want average..