This website is for reference purposes only. Users are responsible for any misuse. The owner is not liable for any consequences.
Back to Database Management Systems (Laboratory)
7.1.1HardCODE

Views - Display Products

Question

Solution

SQL

CREATE VIEW available_products AS
SELECT name, stock_qty
FROM products
WHERE stock_qty > 0;

2/2 test cases passed

No hidden test cases