1.12.1 Example 1: Determine the maximum, minimum, and average quantities purchased
Determine the maximum, minimum, and average value of the quantity purchased (PUR-NUM) for product code P002 in the sales history table (SALESLIST).
- Table to search
- Specification example
-
SELECT MAX("PUR-NUM"),MIN("PUR-NUM"),AVG("PUR-NUM") FROM "SALESLIST" WHERE "PUR-CODE"='P002'
- Retrieval results