CREATE TABLE EMP(Id integer PRIMARY KEY, FirstName text, LastName text, salary integer);
INSERT INTO EMP VALUES(1, 'Kamisato', 'Ayaka', 2500);
INSERT INTO EMP VALUES(2, 'Ajax', 'Tartaglia', 5000);
INSERT INTO EMP VALUES(3, 'Xiao', 'Edgelord', 3300);
INSERT INTO EMP VALUES(4, 'Jane', 'Doe', 3500);
INSERT INTO EMP VALUES(5, 'Hu', 'Tao', 4000);
INSERT INTO EMP VALUES(6, 'Rex', 'Lapis', 7000);
INSERT INTO EMP VALUES(7, 'Venti', 'Barbatos', 3700);
INSERT INTO EMP VALUES(8, 'Aether', 'Lumine', 7000);
INSERT INTO EMP VALUES(9, 'Raiden', 'Shogun', 2600);
INSERT INTO EMP VALUES(10, 'Yae', 'Miko', 2700);

select LastName, LPAD(salary,15,'$') AS "SALARY" from EMP;