Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need a query that list the total sales for years after 2003. I using MySQL workbench. The query i wrote is showing years from
I need a query that list the total sales for years after 2003. I using MySQL workbench. The query i wrote is showing years from 2003 - 2005. I want it to show total sales from 2004 and up.
select year(orderdate) as year, sum(quantityOrdered * priceEach) As total from orders inner join orderdetails using (orderNumber) where status = 'shipped' group by year(orderdate);
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started