FREE AI-Enhanced Online SQL Server Compiler

Untitled*

You must execute the code again to save those values in the database.

CREATE TABLE Customers (
    customer_id INT PRIMARY KEY,
    CompanyName VARCHAR(100),
    ContactName VARCHAR(100)
  );
  
  
  INSERT INTO Customers (customer_id, CompanyName, ContactName) VALUES 
(1, 'Tech Solutions Inc.', 'Andie A'),
(2, 'Green Earth Ltd.', 'Billy B'),
(3, 'Urban Outfitters', 'Charlie C'),
(4, 'Fresh Groceries', 'David D');

CREATE TABLE Orders (
    order_id INT PRIMARY KEY,
    customer_id INT,
    total_amount DECIMAL(10,2),
    order_date DATE,
    FOREIGN KEY (customer_id) REFERENCES Customers(customer_id)
);

INSERT INTO Orders (order_id, customer_id, total_amount, order_date) VALUES 
(101, 1, 500.00, '2024-01-15'),
(102, 1, 1200.00, '2024-02-10'),
(103, 2, 250.00, '2024-02-20'),
(104, 3, 750.00, '2024-03-05'),
(105, 4, 100.00, '2024-03-15');

/*SELECT o.order_id, o.total_amount,
       (SELECT CompanyName 
        FROM Customers c 
        WHERE c.customer_id = o.customer_id) AS CompanyName
FROM Orders o;*/
  
  SELECT o.order_id, o.total_amount, c.CompanyName
FROM Orders o
JOIN Customers c ON o.customer_id = c.customer_id;

order_id	total_amount	CompanyName
101	500.00	Tech Solutions Inc.
102	1200.00	Tech Solutions Inc.
103	250.00	Green Earth Ltd.
104	750.00	Urban Outfitters
105	100.00	Fresh Groceries

(4 rows affected)

(5 rows affected)

(5 rows affected)