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 |