/* 6-7．単価1000円以上の商品の販売履歴を確認 */

select s2.sale_id, s2.sale_date, s2.customer, s2.is_delivery, s2.note
from sale2 as s2 join product as p on s2.product_code = p.product_code
where p.product_price >= 1000
order by s2.sale_id;