Description

Create a view v_shop_catalog with the columns product_id, product_name, category_name and price: one row for each product customers can buy (is_available is true), with the name of its category.

Then finish with exactly this query:

Code
SELECT product_name, category_name, price
FROM v_shop_catalog
WHERE price < 1000
ORDER BY price, product_name;

Tables