How to sort the Date Names accordingly using SQL

I have this code that successfully displayed the number of orders according to the day-name of the week. However, I wanted to display the days name sorted accordingly.
I have this code below:

SELECT 
    DATENAME(dw,orderDate) AS day_of_week, 
    COUNT(orderID) AS total_orders
FROM 
    Orders
GROUP BY 
 DATENAME(dw,orderDate)

Here’s the output: But I wanted the Days(name) sorted from Monday, Tuesday, Wednesday.. and so on.
enter image description here

Any idea? Thank you in advance.

You need to sign in to view this answers