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
Telegram: DB developers channel