The following query uses CO schema on LiveSQL, and returns the month with the highest number of orders $($disregarding the status$)$ in $2018.$

SELECT EXTRACT $($MONTH FROM ORDER DATETIME$)$ "Month"

COUNT $($ORDER$\_$ID$)"$# of Orders

FROM CO$.$ ORDERS

WHERE EXTRACT$($YEAR FROM ORDER DATETIME$)$

$=2018$

GROUP BY EXTRACT $($MONTH FROM ORDER DATETIME$)$

order by COUNT $($ORDER$\_$ID$)$ DESC

FETCH FIRST $1$ ROW only;

You can use the above query $($with some changes$)$ to find which of the statements below is true.

Question $11$ Answer

a$.$

In $2018,$ the highest number of orders was in February.

b$.$

In $2018,$ the highest number of orders was in October.

c$.$

In $2018,$ the highest number of orders was in May.

d$.$

In $2019,$ the highest number of orders was in October.

e$.$

In $2019,$ the highest number of orders was in January.