CREATE TABLE daily_sales 
(
    transaction_date DATE PRIMARY KEY,
    sales numeric
)

INSERT INTO daily_sales(transaction_date, sales)
VALUES 
('2022-01-01',647),
('2022-01-02',561),
('2022-01-03',741),
('2022-01-04',970),
('2022-01-05',1062),
('2022-01-06',1072),
('2022-01-07',805),
('2022-01-08',662),
('2022-01-09',1083),
('2022-01-10',970)