# 成功购买 c++或者java或者python id排序
select
    *
from
    order_info
where
    status='completed'
    and
    product_name in('C++','Java','Python')
    and
    timestampdiff(day,'2025-10-15',date)>=0
order by
    id