LO SQL Query Tutorial Database

CREATE TABLE "Skills" (
"ID" INT GENERATED BY DEFAULT AS IDENTITY,
"Title" VARCHAR(50) NOT NULL,
"Description" VARCHAR(256),
CONSTRAINT TITLE_NOT_BLANK
CHECK(TRIM(BOTH FROM "Title") <> '')
);

CREATE TABLE "TeamMembers" (
"ID" INT GENERATED BY DEFAULT AS IDENTITY,
"FirstName" VARCHAR(50) NOT NULL,
"LastName" VARCHAR(50) NOT NULL,
"DateOfHire" DATE NOT NULL,
"SkillID" INT,
"City" VARCHAR(50),
"Married" BOOLEAN DEFAULT FALSE,
CONSTRAINT FNAME_NOT_BLANK
CHECK(TRIM(BOTH FROM "FirstName") <> ''),
CONSTRAINT LNAME_NOT_BLANK
CHECK(TRIM(BOTH FROM "LastName") <> ''),
FOREIGN KEY ("SkillID") REFERENCES "Skills"("ID")
);

CREATE TABLE "Projects" (
"ID" INT GENERATED BY DEFAULT AS IDENTITY,
"Title" VARCHAR(50) NOT NULL,
"Description" VARCHAR(256),
"Start" DATE,
"Due" DATE,
CONSTRAINT PTITLE_NOT_BLANK
CHECK(TRIM(BOTH FROM "Title") <> '')
);

CREATE TABLE "TeamMember2Project" (
"TeamMemberID" INT,
"ProjectID" INT,
FOREIGN KEY ("TeamMemberID") REFERENCES "TeamMembers"("ID"),
FOREIGN KEY ("ProjectID") REFERENCES "Projects"("ID"),
PRIMARY KEY ("TeamMemberID", "ProjectID")
);

INSERT INTO "Skills"
("Title", "Description")
VALUES
('Programmer', 'The one who codes');

INSERT INTO "Skills"
("Title", "Description")
VALUES
('Artist', 'Images and graphics');

INSERT INTO "Skills"
("Title", "Description")
VALUES
('Desinger', 'The one who puts it all together');

INSERT INTO "TeamMembers"
("FirstName", "LastName", "DateOfHire", "SkillID", "City", "Married")
VALUES
('Johnny', 'Walker', '2010-05-01', 0,  'New York', TRUE);

INSERT INTO "TeamMembers"
("FirstName", "LastName", "DateOfHire", "SkillID", "City", "Married")
VALUES
('Sandy', 'Walker', '2012-04-15', 2, 'New York', TRUE);

INSERT INTO "TeamMembers"
("FirstName", "LastName", "DateOfHire", "SkillID", "City", "Married")
VALUES
('Johnny', 'Smith', '2011-08-05', 1, 'New Town', TRUE);

INSERT INTO "TeamMembers"
("FirstName", "LastName", "DateOfHire", "SkillID", "City", "Married")
VALUES
('Sandy', 'Newsome', '2007-10-23', 2, 'New Town', FALSE);

INSERT INTO "TeamMembers"
("FirstName", "LastName", "DateOfHire", "SkillID", "City", "Married")
VALUES
('Frank', 'Jenson', '1999-01-01', 1, 'Franklin', FALSE);

INSERT INTO "TeamMembers"
("FirstName", "LastName", "DateOfHire", "SkillID", "City", "Married")
VALUES
('Harvey', 'Benson', '2003-03-12', 0, 'Franklin', TRUE);

INSERT INTO "TeamMembers"
("FirstName", "LastName", "DateOfHire", "SkillID", "City", "Married")
VALUES
('Michael', 'Benton', '2012-04-28', 2, 'New Town', TRUE);

INSERT INTO "TeamMembers"
("FirstName", "LastName", "DateOfHire", "SkillID", "City", "Married")
VALUES
('George', 'Hamelton', '1997-02-21', 0, 'New York', FALSE);

INSERT INTO "TeamMembers"
("FirstName", "LastName", "DateOfHire", "SkillID", "City", "Married")
VALUES
('Nadia', 'Donovan', '2013-11-11', 1, 'New York', TRUE);

INSERT INTO "TeamMembers"
("FirstName", "LastName", "DateOfHire", "SkillID", "City", "Married")
VALUES
('Patty', 'Donovan', '2014-02-11', 0, 'New York', FALSE);



INSERT INTO "Projects"
("Title", "Description", "Start", "Due")
VALUES
('ACME Web Site', 'To showcase their products', '2014-08-05', '2014-10-01');

INSERT INTO "Projects"
("Title", "Description", "Start", "Due")
VALUES
('Bugs Bunny Ad', 'Advertise new show', '2014-06-05', '2014-12-01');

INSERT INTO "Projects"
("Title", "Description", "Start", "Due")
VALUES
('Giant Sling Shot', 'New redesign', '2014-11-01', '2015-01-01');

INSERT INTO "Projects"
("Title", "Description", "Start", "Due")
VALUES
('ACME Mobile App', 'Buy stuff from your phone.', '2014-07-15', '2014-08-31');


INSERT INTO "TeamMember2Project"
("TeamMemberID", "ProjectID")
VALUES
(0,0);

INSERT INTO "TeamMember2Project"
("TeamMemberID", "ProjectID")
VALUES
(4,0);

INSERT INTO "TeamMember2Project"
("TeamMemberID", "ProjectID")
VALUES
(3,0);

INSERT INTO "TeamMember2Project"
("TeamMemberID", "ProjectID")
VALUES
(1,1);

INSERT INTO "TeamMember2Project"
("TeamMemberID", "ProjectID")
VALUES
(2,1);

INSERT INTO "TeamMember2Project"
("TeamMemberID", "ProjectID")
VALUES
(8,2);

INSERT INTO "TeamMember2Project"
("TeamMemberID", "ProjectID")
VALUES
(6,2);

INSERT INTO "TeamMember2Project"
("TeamMemberID", "ProjectID")
VALUES
(7,3);

INSERT INTO "TeamMember2Project"
("TeamMemberID", "ProjectID")
VALUES
(3,3);