Untitled
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