-- Query 22: nombre de factures établies chaque jour

SELECT
    DATE_FORMAT(facture.datefacture, "%d/%m/%y") AS 'date',
    COUNT(facture.numfacture) AS 'nb factures'
FROM facture
GROUP BY facture.datefacture
ORDER BY facture.datefacture;

/* == RESULT ==
"Date","Nb factures"
"01/12/05",1
"02/12/05",2
"04/12/05",2
"05/12/05",1
"06/12/05",1
"07/12/05",1
"08/12/05",1
"09/12/05",4
"10/12/05",1
"11/12/05",2
"12/12/05",2
"21/01/06",4
"22/01/06",5
"21/02/06",4
"22/02/06",5
*/