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