new

CREATE TABLE sales(
  order_id INTEGER,
  order_date DATE,
  product TEXT,
  category TEXT,
  region TEXT,
  sales real
);
INSERT INTO sales VALUES 
(1, '2023-01-10', 'Laptop', 'Electronics', 'East', 55000), 
(2, '2023-01-12', 'Mobile', 'Electronics', 'West', 25000), 
(3, '2023-02-05', 'Chair', 'Furniture', 'North', 8000), 
(4, '2023-02-20', 'Table', 'Furniture', 'South', 12000), 
(5, '2023-03-10', 'Headphones', 'Electronics', 'East', 4000), 
(6, '2023-03-18', 'Shoes', 'Fashion', 'West', 6000), 
(7, '2023-04-02', 'Watch', 'Fashion', 'North', 9000), 
(8, '2023-04-15', 'Printer', 'Electronics', 'South', 15000), 
(9, '2023-05-01', 'Sofa', 'Furniture', 'East', 30000), 
(10,'2023-05-10', 'Camera', 'Electronics', 'West', 45000);
SELECT * FROM sales;