Codecademy export

test.sqlite

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;
  
  SELECT customers.customer_name, COUNT(orders.subscription_id) AS 'Subscriptions'
  FROM customers
  JOIN orders
    ON customers.customer_id = orders.customer_id
  GROUP BY 1;