题解 | #牛客的课程订单分析(一)#

/* 
    提醒一点,非整数类型字段使用时要加' ',我就是这里错的
    DATEDIFF(endDATE,startDATE)
*/
SELECT
    id,
    user_id,
    product_name,
    status,
    client_id,
    date
FROM
    order_info
WHERE
    product_name IN ('C++', 'Java', 'Python')
    AND status = 'completed'
    AND DATEDIFF (date, '2025-10-15') > 0
ORDER BY
    id ASC;