-- create a table
CREATE TABLE BookCopy (
  BookId Text PRIMARY KEY,
  BookTitle TEXT NOT NULL
);
-- insert some values 

INSERT INTO BookCopy VALUES ('HT001', 'HTML 4 Fun'); 
INSERT INTO BookCopy VALUES ('PB002', 'Python Basics'); 
INSERT INTO BookCopy VALUES ('PB003', 'Python Basics');
INSERT INTO BookCopy VALUES ('PB004', 'Python Basics'); 
INSERT INTO BookCopy VALUES ('PB005', 'Python Basics');
INSERT INTO BookCopy VALUES ('PB006', 'Python Basics'); 
INSERT INTO BookCopy VALUES ('GC001', 'GCSE Computing');
INSERT INTO BookCopy VALUES ('GC002', 'GCSE Computing');
INSERT INTO BookCopy VALUES ('GC003', 'GCSE Computing');
INSERT INTO BookCopy VALUES ('GC004', 'GCSE Computing'); 
SELECT * FROM BookCopy;

-- create a table
CREATE TABLE Student(
    StudentID TEXT PRIMARY KEY,
    FirstName TEXT NOT NULL,
    LastName TEXT NOT NULL,
    YearGroup INTEGER NOT NULL
);
-- insert some values

INSERT INTO Student VALUES ('TUC004', 'Barry','Tucker',8); 
INSERT INTO Student VALUES ('WAY002', 'Shania','Wayneton',10); 
INSERT INTO Student VALUES ('KOW001', 'Bartek','Kowaiski',11); 
INSERT INTO Student VALUES ('WAY003', 'Faisal','Azeez',9); 
INSERT INTO Student VALUES ('BAK007', 'Jolene','Baker',11); 
INSERT INTO Student VALUES ('ANA002', 'Aisha','Anand',11); 
INSERT INTO Student VALUES ('OKA003', 'Sani','Okafor',10); 
INSERT INTO Student VALUES ('GON001', 'Brian','Gonzalez',11); 
INSERT INTO Student VALUES ('GON002', 'Bryani','Gonzalez',11);

-- create a table
CREATE TABLE Loan(
    LoanID TEXT PRIMARY KEY,
    StudentID TEXT NOT NULL,
    CopyID TEXT NOT NULL,
    DepositPaid CURRENCY NOT NULL
);
-- insert some values

INSERT INTO Loan VALUES ('L0001','TUC004', 'HT001',0.5); 
INSERT INTO Loan VALUES ('L0002', 'WAY002','GC004',2.00); 
INSERT INTO Loan VALUES ('L0003', 'KOW001','GC001',2.00); 
INSERT INTO Loan VALUES ('L0004', 'TUC004','PB002',0.75); 
INSERT INTO Loan VALUES ('L0005', 'BAK007','RG001',2.50); 
INSERT INTO Loan VALUES ('L0006', 'BAK007','GC002',2.00); 
INSERT INTO Loan VALUES ('L0007', 'OKA003','GC003',2.00); 
INSERT INTO Loan VALUES ('L0008', 'GON001','PB003',2.00); 
INSERT INTO Loan VALUES ('L0009', 'GON002','PB004',2.00); 

SELECT DISTINCT Firstname, Lastname, BookTitle
FROM Student, Loan, BookCopy
WHERE Student.StudentID = Loan.LoanID
AND BookTitle = 'Python Physics',