CREATE TABLE Customers(
CustomerID INT PRIMARY KEY,
Name VARCHAR(100),
Email VARCHAR (100),
Country VARCHAR(100)
);

INSERT INTO Customers(CustomerID, Name, Email, Country) VALUES

(1,"sarah smith","sarah@gmail.com","uganda"),
(2,"sarah doe","sarah1@gmail.com","Rwanda"),
(3,"mike williams","mike@gmail.com","Burundi");

SELECT * FROM Customers;

CREATE TABLE orders(
    OrderID INT PRIMARY KEY,
    CustomerID INT,
    orderdate VARCHAR(100),
    Amount VARCHAR(100),
    CONSTRAINT Odres_CustomerID_FK FOREIGN KEY(CustomerID) REFERENCES Customers(CustomerID)
      );  

INSERT INTO orders(orderID,CustomerID, orderdate, Amount)VALUES
    
(101,1,"2024-01-05","$1200"),
(102,1,"2024-01-10","$350"),
(103,2,"2024-01-15","$500"),
(104,3,"2024-01-20","$800");

SELECT * FROM orders;