select sku,location,sum(part_qty) from Demand_Daily_History
where sku = '10001'
group by sku,location


SKU      Location Qty
 
10001    CARSON   1
10001    VA       5

select sku, case location when 'CARSON' then sum(part_qty) end,
case location when 'VA' then sum(part_qty) end
from Demand_Daily_History
where sku = '10001'
group by sku,location


output:
SKU 	CARSON 	VA
 
10001 	1 	NULL
10001 	NULL 	5


Required
SKU               carson           VA
10001               1                   5