Need to get all orders in a date range by sql

[navido]

Thanks for each one of you.

jc8125:

It worked, however two things

I exported to "CSV for MS excel" and the "orders_id" doesnt show up with the ordernumber, but the text "orders_id". See the picture below



Also when try to use the Autosum in excel, it does not summarize the orders total column. It just shows 0. This is because it doesnt recognize is as integer or number. How to solve this?