SELECT * FROM student;

SELECT Title, Author FROM book WHERE Author = 'George Orwell';

SELECT DISTINCT book.Title 
FROM book, borrow 
WHERE book.BookID = borrow.BookID;

SELECT student.LastName, student.FirstName 
FROM student, borrow, book 
WHERE 	student.StudentID = borrow.StudentID 
	AND borrow.BookID = book.BookID 
	AND book.Title = '1984';

SELECT student.LastName, student.FirstName, book.Title, borrow.BorrowDate, borrow.ReturnDate 
FROM student, borrow, book 
WHERE 	student.StudentID = borrow.StudentID 
	AND borrow.BookID = book.BookID 
ORDER BY borrow.BorrowDate DESC;