sql Pivot

Witam
Mam zapytanie

select sc.name "GRUPA", sp.Row_nr "NUMER", count(*) "Ilość", 'wolne' "Status"
  from storageplaces sp, sp_classes sc, storageareas sa, qcm_warehouses w
 where sp.status != '--'
   and sp.sp_class_id = sc.sp_class_id
   and sp.sa_id = sa.sa_id
   and sa.wh_id = w.wh_id
 and w.wh_nr ='EKIP'
 
   and not exists
 (select 1 from load_units_fast luf where luf.sp_id = sp.sp_id)
 group by sc.name, w.wh_nr,sp.Row_nr
order by sp.Row_nr

jak zrobić do niego pivot

Skoro Witasz to raczej nie do mnie mówisz, ale łap http://andrzejklusiewicz.blogspot.com/2013/10/pivot-tabele-przestawne-w-oracle.html?m=1

i jeszcze http://blog.dataconsulting.pl/2012/02/tabele-przestawne-pivot-queries-w-oracle-10g-i-11g-zamiana-wiersze-na-kolumny/