About this document
SQL Commandes et Gestion Clients by Charafeddine ELBAHJA is a document available to read on EtoBox.
The document contains a series of SQL queries and statements: 1) It selects client data from the client table, updates order line and order tables, and performs various joins and aggregations to calculate order totals and counts. 2) It then adds a category field to orders, populates it with ranges based on order total amounts, and creates a reference table to define the categories. 3) Finally, it deletes order lines and orders before a specified date to clean up old data.
- Author
- Charafeddine ELBAHJA
- Language
- EN