DDL - CREATE

Question

Solution

SQL


CREATE TABLE employees (
	employeeID INT PRIMARY KEY,
	firstName VARCHAR(50) NOT NULL,
	lastName VARCHAR(50) NOT NULL,
	birthDate DATE,
	hireDate DATE,
	salary DECIMAL(10,2),
	CHECK (salary >= 0)
)

1/1 test cases passed

No hidden test cases