/* 6-4．配送履歴を確認 − 結合と条件 */

select s2.sale_date, p.product_name, s2.product_count, s2.customer
from sale2 as s2 join product as p on s2.product_code = p.product_code
where s2.is_delivery = true;