question :
Dave is thinking of hiring more staff and wants to know when to roster these staff on to provide the maximum help.
What he needs is, for each day of the week (show the day names), the total number of customers served that day and the average number of customers served by each employee. Only include employees who were working on that day (i.e. employees who actually served customers that day).
Tables :
ORDERS
ORDERID CUSTOMERID EMPLOYEEID ORDERDATE
je pense qu il y a besoin que dun seul tableau donc je n emetrai pas la suite.
Pour convertir la date en jour, il faut faire ca :
TOCHAR (ORDERS.ORDERDATE, 'DD')
Mais bon sa ne me permet pas dafficher TOUT les jours d elasemaone mais seulement ceux ou il ya eu une commande.
output devrais resembler a ca :
DAYS NBR_OF_CUST_SERVED_THAT_DAY AVG_CUST_SERVED_DAY
MONDAY 25 2.3
TUESDAY 6 ...
WEDNWSDAY ....
THURSDAY
FRIDAY
SATURADAY
SUNDAY ??
HEllllp
---------------
jeunes con de la derniere averse, vieux con des neiges d'antant.