Coding task · SQL and MySQL course · Module 11: Capstone project

Create a view of available books

Save a frequently used query as a view (VIEW) that behaves like a table.

Task

Write a CREATE VIEW statement that creates the dostepne_ksiazki view, which retrieves tytul and cena from the ksiazki table for available books (dostepna = 1).