Untitled

 avatar
unknown
plain_text
a year ago
445 B
4
Indexable
CREATE TABLE Employees (
ID INT PRIMARY KEY, Name VARCHAR(100),
DepartmentID INT,
Salary DECIMAL (10, 2)
CREATE TABLE Departments (
ID INT PRIMARY KEY,
Name VARCHAR (100)
INSERT INTO Departments (ID, Name) VALUES (1, 'Engineering'), (2, 'Marketing'),
(3, 'Finance');
INSERT INTO Employees (ID, Name, DepartmentID, Salary)
VALUES (1, 'John Doe', 1, 60000),
(2,
"Jane Smith', 1, 65000),
(3,
'Mike Johnson', 2, 55000),
(4,
'Emily Brown', 3, 70000);
Editor is loading...
Leave a Comment