Sales table (SALES)

 

The sales table describes the information about each sale for each sales person.

The sales table is created with the following CREATE TABLE statement:

CREATE TABLE SALES 
             (SALES_DATE DATE, 
              SALES_PERSON VARCHAR(15), 
              REGION VARCHAR(15), 
              SALES INTEGER)

The table below gives the contents of the columns.

Column name	Description
SALES_DATE	Date the sale was made
SALES_PERSON	Person making the sale
REGION	Region where the sale was made
SALES	Number of sales

• SALES
  Here is a complete listing of the data in the SALES table.

 

Parent topic:

DB2 Universal Database for iSeries sample tables