Answer:
see below
Step-by-step explanation:
SELECT date_format(order_date,"%Y"), date_format(order_date,"%a-%d-%Y"), date_format(order_date,"%r")
8.8m questions
11.4m answers