SELECT orderId,creationDateTime FROM orderitems_printed WHERE creationDateTime BETWEEN "2021-02-02" AND "2021-02-04"

SELECT orderId,creationDateTime FROM orderitems_printed WHERE creationDateTime>="2021-02-03" AND creationDateTime<="2021-02-04"

SELECT DISTINCT orderId,creationDateTime FROM orderitems_printed WHERE creationDateTime BETWEEN "2021-02-02" AND "2021-02-04"

SELECT COUNT(DISTINCT orderId) AS "Nombre de demandes de travaux traités" FROM orderitems_printed WHERE creationDateTime BETWEEN "2021-02-03" AND "2021-02-04"

SELECT SUM(numberOfSheetsides*copies) AS "Total Copies A3" FROM orderitems_printed WHERE creationDateTime BETWEEN "2021-02-03" AND "2021-02-04" AND outputFormat="A3"

SELECT orderId,COUNT(*) AS NombreOrder FROM orderitems_printed WHERE creationDateTime BETWEEN "2021-02-02" AND "2021-02-04" GROUP BY orderId


SELECT orderId,creationDateTime,title FROM orderitems_printed WHERE creationDateTime BETWEEN "2021-02-02" AND "2021-02-04" AND title LIKE "P%"
SELECT orderId,creationDateTime,title FROM orderitems_printed WHERE creationDateTime BETWEEN "2021-02-02" AND "2021-02-04" AND title LIKE "%C%"


SELECT orderId,creationDateTime,title FROM orderitems_printed WHERE creationDateTime BETWEEN "2021-02-02" AND "2021-02-04" ORDER BY orderId ASC
SELECT orderId,creationDateTime,title FROM orderitems_printed WHERE creationDateTime BETWEEN "2021-02-02" AND "2021-02-04" ORDER BY orderId DESC

SELECT orderitems_copyright.author,orderitems_copyright.title,orderitems_copyright.editor,orderitems_copyright.edition,orderitems_copyright.pages,orderitems_submitted.copies FROM orderitems_copyright INNER JOIN orderitems_submitted ON orderitems_copyright.orderId=orderitems_submitted.orderId WHERE orderitems_submitted.creationDateTime BETWEEN "2021-02-03" AND "2021-02-04"

SELECT SUM(copies),outputFormat FROM orderitems_printed WHERE outputFormat IN ('A3','SRA3') GROUP BY outputFormat

GROUP BY outputFormat,ownerLogin,projectName

SELECT strftime("%Y-%m-%d", orderitems_printed.printDateTime) as "Date d'impression",SUM(orderitems_printed.numberOfSheetsidesBW*orderitems_printed.copies) as "Nombre Total de faces NB",SUM(orderitems_printed.numberOfSheetsidesColor*orderitems_printed.copies) "Nombre Total de faces Couleur",clustername as "Imprimante" FROM orderitems_printed WHERE printDateTime BETWEEN "2026-03-01" AND "2026-04-01" GROUP BY strftime("%Y-%m-%d", orderitems_printed.printDateTime),clustername