Question 14

Table Name: Checked

Relevant Table(s):

Checked(First_Name (Text), Last_Name (text), Book_ID (INT))

Books(Book_ID (INT), Book_Name(Text), Author(Text))

First_Name Last_Name Book_ID
John  Brook B01
Van der Merve B02
Ackerman Brook B03
Suyash Sharma B04
Simrit Sharma B05
Jessica Roy B06
Jenny Smith B07

 

Book_ID  Book_Name Author
B01 English Martin
B02 Maths John 
B03 English Martin

QUERY: Write a Query that returns the first name and last name of people who checked out a book by Martin.

Execute:      SELECT DISTINCT First_Name, Last_Name
                     FROM Checked
                     INNER JOIN Books ON Checked.Book_ID = Books.Book_ID
                     WHERE Author = 'Martin';

Answer:

First_Name Last_Name
John  Brook
Ackerman Brook