This returns a table:
Code: Select all
Month | Sum | Count
11 | 100 | 5
10 | 101 | 6
Code: Select all
Month | Sum | Count
November | 100 | 5
October | 101 | 6
What the best method to achieve this result, if possible?
My query:
Code: Select all
SELECT
MONTH("Datetime") "Month"
,SUM("Revenue") "Sum"
,COUNT("Items") "Count"
FROM
"table"
WHERE
YEAR("Datetime") = 2017
GROUP BY
MONTH("Datetime")
ORDER BY
MONTH("Datetime") DESC