text: WITH previous_query AS (
     SELECT customer_id,
        COUNT(subscription_id) AS 'subscriptions'
     FROM orders
     GROUP BY customer_id
  )
  SELECT customers.customer_name, 
     previous_query.subscriptions
  FROM previous_query
  JOIN customers
    ON previous_query.customer_id = customers.customer_id;