SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Department( DNo int, DName VARCHAR(20), ManagerSSN int, MgrStartdate date); INSERT into Department VALUES(1,'Technical',30,'2023-10-13'); INSERT into Department VALUES(2,'Design',25,'2022-09-15'); INSERT into Department VALUES(3,'Backend',70,'2022-07-18'); INSERT into Department VALUES(4,'Technical',13,'2012-08-23'); INSERT into Department VALUES(4,'Frontend',17,'2013-10-27'); INSERT into Department VALUES(3,'Frontend',7,'1999-06-18'); INSERT into Department VALUES(2,'Design',71,'2010-05-13'); INSERT into Department VALUES(1,'Technical',31,'2021-10-14'); INSERT into Department VALUES(3,'Backend',56,'2022-04-29'); INSERT into Department VALUES(4,'Frontend',50,'2023-12-13'); SELECT LTRIM(SUBSTR(DName,1,4)) FROM Department