Anyone want to help me with this SQL-code? http://pastebin.com/VWnJmM34
I want to add a column that shows the number of cupcakes the customer bought for that specific order_date. Is this possible? How do I do it?

Is there more than one order per day? Do you have a flat or relational design?

I want to add a column that shows the number of cupcakes the customer bought for that specific order_date

I assume you are trying to add that column in SQL output, not in the actual table.

Kindly post your table structure and relation between them.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.