Query Asistió / (Totales - Canceladas)

SELECT
  SUM(
      CASE
      WHEN ROUND(source.AT, 1) = 0.0
        THEN 1
      ELSE 0
      END
  ) AS 'AT00',
  SUM(
      CASE
      WHEN ROUND(source.AT, 1) = 0.1
        THEN 1
      ELSE 0
      END
  ) AS 'AT01',
  SUM(
      CASE
      WHEN ROUND(source.AT, 1) = 0.2
        THEN 1
      ELSE 0
      END
  ) AS 'AT02',
  SUM(
      CASE
      WHEN ROUND(source.AT, 1) = 0.3
        THEN 1
      ELSE 0
      END
  ) AS 'AT03',
  SUM(
      CASE
      WHEN ROUND(source.AT, 1) = 0.4
        THEN 1
      ELSE 0
      END
  ) AS 'AT04',
  SUM(
      CASE
      WHEN ROUND(source.AT, 1) = 0.5
        THEN 1
      ELSE 0
      END
  ) AS 'AT05',
  SUM(
      CASE
      WHEN ROUND(source.AT, 1) = 0.6
        THEN 1
      ELSE 0
      END
  ) AS 'AT06',
  SUM(
      CASE
      WHEN ROUND(source.AT, 1) = 0.7
        THEN 1
      ELSE 0
      END
  ) AS 'AT07',
  SUM(
      CASE
      WHEN ROUND(source.AT, 1) = 0.8
        THEN 1
      ELSE 0
      END
  ) AS 'AT08',
  SUM(
      CASE
      WHEN ROUND(source.AT, 1) = 0.9
        THEN 1
      ELSE 0
      END
  ) AS 'AT09',
  SUM(
      CASE
      WHEN ROUND(source.AT, 1) = 1.0
        THEN 1
      ELSE 0
      END
  ) AS 'AT10',
  COUNT(*)
FROM (SELECT
        r.customer_id,
        COALESCE(
            SUM(
                CASE
                WHEN r.status = 'seated'
                  THEN 1
                WHEN r.status = 'completed'
                  THEN 1
                WHEN r.status = 'reserved'
                  THEN 1
                ELSE 0
                END
            ) / (
              COUNT(*) - SUM(
                  CASE
                  WHEN r.status = 'canceled'
                    THEN 1
                  ELSE 0
                  END
              )
            )
            , 0
        ) AS 'AT'
      FROM reservations r
      WHERE r.created_at > '2018-01-01'
        AND r.created_at < '2018-09-01'
        AND r.customer_id IS NOT NULL
        AND r.origin LIKE 'restorando'
      GROUP BY 1) AS source;