q9

(SELECT good.name AS good_name
FROM category_has_good
INNER JOIN good
ON good.id = category_has_good.good_id
INNER JOIN category
ON category.id = category_has_good.category_id
WHERE category.name = 'Cakes' )
UNION
(SELECT good.name AS good_name
FROM good
INNER JOIN sale_has_good
ON good.id = sale_has_good.good_id
INNER JOIN sale
ON sale.id = sale_has_good.sale_id
INNER JOIN status
ON status.id = sale.status_id
WHERE status.name = 'delivering')
LIMIT 10;