CREATE TABLE Customers (
CustomerID INT PRIMARY KEY,
Name VARCHAR(50),
Email VARCHAR(100),
Age INT
);
CREATE TABLE Orders (
OrderID INT PRIMARY KEY,
CustomerID INT,
Product VARCHAR(50),
Quantity INT,
OrderDate DATE,
FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID)
);
INSERT INTO Customers (CustomerID, Name, Email, Age)
VALUES
(1, 'John Smith', 'john@example.com', 25),
(2, 'Emily Johnson', 'emily@example.com', 32),
(3, 'Michael Davis', 'michael@example.com', 41),
(4, 'Sophia Wilson', 'sophia@example.com', 19),
(5, 'Daniel Brown', 'daniel@example.com', 37);
INSERT INTO Orders (OrderID, CustomerID, Product, Quantity, OrderDate)
VALUES
(1, 1, 'Widget A', 5, '2023-06-01'),
(2, 1, 'Widget B', 3, '2023-06-03'),
(3, 2, 'Widget A', 10, '2023-06-02'),
(4, 3, 'Widget C', 8, '2023-06-04'),
(5, 4, 'Widget B', 2, '2023-06-05'),
(6, 5, 'Widget A', 4, '2023-06-03');