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 ...