1.13.3 Example 3: Determine the sum and average of the quantities purchased for each product code
Determine the sum and average of the quantities purchased on or after September 3, 2011 for each product code (PUR-CODE) in the sales history table (SALESLIST).
- Table to search
- Specification example
-
SELECT "PUR-CODE",SUM("PUR-NUM"),AVG("PUR-NUM") FROM "SALESLIST" WHERE "PUR-DATE">=DATE'2011-09-03' GROUP BY "PUR-CODE"
- Retrieval results