CREATE TABLE EMP(Id integer PRIMARY KEY, FirstName text, LastName text, hire date);

INSERT INTO EMP VALUES(1, 'Kamisato', 'Ayaka', 20040923);
INSERT INTO EMP VALUES(2, 'Ajax', 'Tartaglia', 20090803);
INSERT INTO EMP VALUES(3, 'Xiao', 'Edgelord', 20130315);
INSERT INTO EMP VALUES(4, 'Jane', 'Doe', 20080530);
INSERT INTO EMP VALUES(5, 'Hu', 'Tao', 20191103);
INSERT INTO EMP VALUES(6, 'Rex', 'Lapis', 20010101);
INSERT INTO EMP VALUES(7, 'Venti', 'Barbatos', 20150412);
INSERT INTO EMP VALUES(8, 'Aether', 'Lumine', 20210912);
INSERT INTO EMP VALUES(9, 'Raiden', 'Shogun', 20040215);
INSERT INTO EMP VALUES(10, 'Yae', 'Miko', 20021213);

SELECT LastName, hire, DATE_FORMAT(hire, '%a') AS "DAY" from EMP order by hire asc;