/* 6-9．売れない商品を確認 */

select p.product_code, p.product_name
from product as p left join sale2 as s2 on p.product_code = s2.product_code
group by p.product_code, p.product_name
having sum(s2.product_count) is NULL
order by p.product_code;