SELECT company, COUNT(city) as LA, 0 as Detroit, 0 as Chicago
FROM customers
where city = 'LA'
GROUP BY company
union all
SELECT company, 0 as LA, COUNT(city) as Detroit, 0 as Chicago
FROM customers
where city = 'Detroit'
GROUP BY company
union all
SELECT company, 0 as LA, 0 as Detroit, COUNT(city) as Chicago
FROM customers
where city = 'Chicago'
GROUP BY company

SELECT company,
       SUM(CASE WHEN CITY = 'LA' THEN 1 ELSE 0 END) as LA,
       SUM(CASE WHEN CITY = 'New York' THEN 1 ELSE 0 END) as NY,
       SUM(CASE WHEN CITY = 'Detroit' THEN 1 ELSE 0 END) as Detroit,
etc
FROM customers
GROUP BY company

SELECT company
     , COUNT(CASE WHEN city = 'LA'       THEN city END) as LA
     , COUNT(CASE WHEN city = 'New York' THEN city END) as NewYork
     , COUNT(CASE WHEN city = 'Detroit'  THEN city END) as Detroit
     , ...