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