Query Canceladas / Totales

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,
        (
          SUM(
              CASE
              WHEN r.status = 'canceled'
                THEN 1
              ELSE 0
              END
          ) / COUNT(*)
        ) 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;