Coding task · SQL and MySQL course · Module 10: Transactions and advanced SQL

A view of available books

The Keeper wants the list of books ready to be borrowed always at hand. Create a view that shows only the available books.

Task

Create a view named dostepne_ksiazki that shows all columns from the ksiazki table, but only those rows where the dostepna column equals 1. Use CREATE VIEW ... AS SELECT ...