Решение к #Задача8:

SELECT c.name AS category_name,
p.name as product_name,
p.description
FROM category c,
product p
WHERE p.category_id = c.category_id
AND c.category_id = 1
ORDER BY p.name

#задача