19 Display the no.of order for each day in the following format. There are "X"(No. of Orders) Orders on "Y"(Date in dd - mon - yy).
SELECT
onum as X,
DATE_FORMAT(odate, ' %d - %m - %y') as Y
FROM
orders;
Output:

SELECT
onum as X,
DATE_FORMAT(odate, ' %d - %m - %y') as Y
FROM
orders;
