SELECT * FROM( select seqanalytics, kolomtellingwaarde, regeltellingwaarde FROM analytics_bindingresults abr)
pivot
(
     count(kolomtellingwaarde)
     for kolomtellingwaarde in ('Wijnegem')
)

SELECT * FROM( select seqanalytics, kolomtellingnaam, regeltellingnaam FROM analytics_bindingresults abr)
pivot
(
      count(tellingwaarde)
      for tellingwaarde in (SELECT kolomtellingwaarde FROM analytics_bindingresults)
)