Produce a summary of the total value of orders (qty ordered * quoted price) by the year
Fantastic news! We've Found the answer you've been seeking!
Question:
Produce a summary of the total value of orders (qty ordered * quoted price) by the year and month number of the order date. Year and month should be separate columns in your query using the Year and Month functions to parse these values from the order date. You should have three summary rows in your final result.
Related Book For
Auditing and Assurance services an integrated approach
ISBN: 978-0132575959
14th Edition
Authors: Alvin a. arens, Randal j. elder, Mark s. Beasley
Posted Date: