Mindbox test

Ответ на тестовое задание для Mindbox, ч.2

select p.name, c.name
from product p
    left join product_and_category pc on p.product_id = pc.product_id
    left join category c on pc.category_id = c.category_id