Untitled

BaiMishan

Mar 17th, 2025

Never

Add comment

Not a member of Pastebin yet? Sign Up, it unlocks many cool features!

MySQL 1.02 KB | None | 0 0

raw download clone embed print report

DROP TABLE IF EXISTS Programmers;
CREATE TABLE programmers(
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
address VARCHAR(255) NOT NULL,
startWorkingDate DATE,
teamLead_id INT DEFAULT NULL,
CONSTRAINT FOREIGN KEY (teamLead_id) REFERENCES programmers(id)
);
INSERT INTO programmers (name, address, startWorkingDate, teamLead_id)
VALUES ('Ivan', 'Sofia', '1999-05-25', NULL),
('Georgi', 'Bulgaria- Sofia Nadezhda', '2002-12-01', 1),
('Todor', 'Sofia - Liylin 7', '2009-11-01', 1),
('Sofiq', 'Sofia - Mladost 4', '2010-01-01', 1),
('Teodor', 'Sofia - Obelya', '2011-10-01', NULL),
('Iliya', 'Sofia - Nadezhda', '2000-02-01', 5),
('Mariela', 'Sofia - Knyajevo', '2005-05-01', 5),
('Elena', 'Sofia - Krasno Selo', '2008-04-01', 5),
('Teodor', 'Sofia - Lozenetz', '2012-04-01', 5);
SELECT progr.name AS ProgrammerName, progr, address AS ProgrammerAddress, teamLeads.name AS TeamLeadName
FROM programmers AS progr JOIN programmers AS teamLeads
WHERE progr.teamLead_id=teamLeads.id;

Add Comment

Please, Sign In to add comment