Problem

Design a database table for a library catalog that includes the following information:
-Title
-Author
-ISBN
-Publisher
-Date published
-Checkout status (i.e. whether the book is currently checked out or not)
Assuming that the library only allows one copy of each book, design a SQL query that will return the titles of all books that are currently checked out.
Example input:
-Title: "The Catcher in the Rye"
-Author: J.D. Salinger
-ISBN: 0316769487
-Publisher: Little, Brown and Company
-Date published: July 16, 1951
-Checkout status: Checked out
-Title: "To Kill a Mockingbird"
-Author: Harper Lee
-ISBN: 0446310786
-Publisher: J.B. Lippincott & Co.
-Date published: July 11, 1960
-Checkout status: Not checked out
Example output:
"The Catcher in the Rye"

Solution

SELECT title FROM library_catalog WHERE checkout_status = 'Checked out';