My query returns weekdays in alphabetical order likes following:
How do I re-write this query and make the weekday shown in the order of:
How do I add a additional column in this query to show a calculated result?
SELECT date_format( GameDate, '%W' ) , SUM( Win ) , SUM( Lost )
WHERE GameDate >= date_sub( now( ) , INTERVAL 500
GROUP BY date_format( GameDate, '%W' )
ORDER BY date_format( GameDate, '%W' )