var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Hey guys i have a question on an assignment that says :
6. Display all the names of customers, order year, and total number of orders they have placed in that year.
So far i got:
SELECT CustName,YEAR(orderdate), COUNT(orderdate)
however it is coming out null. Any help?
This line has a mistake:
1997 is a number, not a date
What were the data in tables customer and orders?
Are there some rows having orders.orderdate=1997?
Anyway, I doubt that the query worked,
because, there was an aggregate function COUNT(orderdate) without GROUP BY clause.