<> means 'is not this'

Sometimes it's easier to say what you don't want. The symbol <> means 'is not equal to', so rows holding that value are left out and everything else comes back. Many databases also accept != for the same thing, but <> works everywhere.

SELECT title
FROM books
WHERE status <> 'borrowed';