(DBLab5ClassWork)

CREATE DATABASE Lab_7;

USE Lab_7;

CREATE TABLE Persons
(
P_Id INT PRIMARY KEY NOT NULL,
LastName VARCHAR(200) NOT NULL,
FirstName VARCHAR(200) NOT NULL,
Address VARCHAR(200) NOT NULL,
City VARCHAR(200) NOT NULL,
);

CREATE TABLE Orders
(
O_Id INT NOT NULL PRIMARY KEY,
OrderNo INT NOT NULL,
P_Id INT NOT NULL,
);

INSERT INTO Persons(P_Id,LastName,FirstName,Address,City)
VALUES(1,'Hansen','Ola','Timoteivn 10','Sandnes');
INSERT INTO Persons(P_Id,LastName,FirstName,Address,City)
VALUES(2,'Svendson','Tove','Borgvm 23','Sandnes');
INSERT INTO Persons(P_Id,LastName,FirstName,Address,City)
VALUES(3,'Petterson','Kari','Storgt 20','Stavanger');

INSERT INTO Orders(O_Id,OrderNo,P_Id)
VALUES(1,77895,3);
INSERT INTO Orders(O_Id,OrderNo,P_Id)
VALUES(2,44678,3);
INSERT INTO Orders(O_Id,OrderNo,P_Id)
VALUES(3,22446,1);
INSERT INTO Orders(O_Id,OrderNo,P_Id)
VALUES(4,24562,1);
INSERT INTO Orders(O_Id,OrderNo,P_Id)
VALUES(5,34764,15);

SELECT Persons.LastName,Persons.FirstName,Orders.OrderNo
FROM Persons
RIGHT JOIN Orders
ON Persons.P_Id=Orders.P_Id
ORDER BY Persons.LastName;

SELECT Persons.LastName,Persons.FirstName,Orders.OrderNo
FROM Persons
LEFT JOIN Orders
ON Persons.P_Id=Orders.P_Id
ORDER BY Persons.LastName;

SELECT Persons.LastName,Persons.FirstName,Orders.OrderNo
FROM Persons
JOIN Orders
ON Persons.P_Id=Orders.P_Id
ORDER BY Persons.LastName;