Swipe to show menu

Challenge: Avoid the Damaged Books

The library decided to mention the condition of the available books to better keep track of which books are suitable to be lent and which need to be preserved.

The condition of a book can be one of the following:

New | Used | Damaged

The books that are damaged cannot be borrowed by anyone. As a librarian, you are required to make a new list of all the available books that can be borrowed.

Task

Swipe to start coding

Write a query to list the names, authors, and publication years of all the books that are borrowable.

The books table includes these columns: id, title, author, book_condition, genre, and publication_year.

Solution

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 2. Chapter 5

Ask AI

Ask anything or try one of the suggested questions to begin our chat

Challenge: Avoid the Damaged Books

The library decided to mention the condition of the available books to better keep track of which books are suitable to be lent and which need to be preserved.

The condition of a book can be one of the following:

New | Used | Damaged

The books that are damaged cannot be borrowed by anyone. As a librarian, you are required to make a new list of all the available books that can be borrowed.

Task

Swipe to start coding

Write a query to list the names, authors, and publication years of all the books that are borrowable.

The books table includes these columns: id, title, author, book_condition, genre, and publication_year.

Solution

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 2. Chapter 5

Switch to desktop for real-world practiceContinue from where you are using one of the options below