Sales design

Set up the sales tables and write skeleton queries.

In this project you will build a sales report database. First step: create the sales table.

CREATE TABLE sales (
  id INT PRIMARY KEY,
  product VARCHAR(50),
  amount DECIMAL(10,2),
  sale_date DATE
);

Skeleton of the sales table.

The table sales is created.

Sales design — details

DECIMAL(10,2) means ten total digits, two after the decimal. Good for monetary amounts.

The sales table holds each sale's date (sale_date DATE), product, customer and amount (amount DECIMAL(10,2)).

Create sales with id, product, amount and sale_date.

Show example solution

CREATE TABLE sales (
  id INT PRIMARY KEY,
  product VARCHAR(50),
  amount DECIMAL(10,2),
  sale_date DATE
)

Add PRIMARY KEY

CREATE TABLE sales (
  id INT ____,
  product VARCHAR(50)
);

Show answer

CREATE TABLE sales (
  id INT PRIMARY KEY,
  product VARCHAR(50)
);