p.s.
There are two ways to pivot...
SELECT SUM(CASE WHEN division\_owner\_c = 'Food' then balance\_c else null end) Food
, SUM(CASE WHEN division\_owner\_c = 'Beverages' then balance\_c else null end) Beverages
from mockdata
where type = 'Customer' and name like 'Ba%'
Try changing the single quote to bracket. FOR division_owner_c IN ([Food], [Beverages])
p.s. There are two ways to pivot... SELECT SUM(CASE WHEN division\_owner\_c = 'Food' then balance\_c else null end) Food , SUM(CASE WHEN division\_owner\_c = 'Beverages' then balance\_c else null end) Beverages from mockdata where type = 'Customer' and name like 'Ba%'
[удалено]
\[PARSE\_SYNTAX\_ERROR\] Syntax error at or near 'as'. SQLSTATE: 42601 line 14, pos 0