Coding task · SQL and MySQL course · Module 10: Transactions and advanced SQL
A view of expensive books
The Keeper needs a ready list of valuable books. Create a view that shows only the expensive books.
Task
Create a view named drogie_ksiazki that shows the tytul and cena columns from the ksiazki table, but only for rows where cena is greater than 50. Use CREATE VIEW ... AS SELECT ...