Ahh!.. So close to the end and I don’t know what’s going on!
It’s been going pretty well until the “Learn” explanation seemed a little scant in 8/10. Now at 9/10 I just don’t feel I have enough information. The parentheses were not explained and the graphic is unclear to me. Hanging on to my sense of humor though!
The Instructions say:
COUNT(subscription_id) as subscriptions
GROUP BY customer_id
Place the above query into a WITH statement using the alias previous_query. Join previous_query with customers and select the following columns:
Admittedly, I’m already lost, but I just went for it anyway:
SELECT customer_id, COUNT(subscription_id) as subscriptions FROM orders GROUP BY customer_id;
WITH previous_query AS (SELECT customers.customer_name, previous_query.subscriptions FROM previous_query JOIN customers ON previous_query.customer_id = customers.customer.id);
What is wrong with my code?