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';
FROM Checked
INNER JOIN Books ON Checked.Book_ID = Books.Book_ID
WHERE Author = 'Martin';
Answer:
First_Name | Last_Name |
John | Brook |
Ackerman | Brook |