题解 | #牛客的课程订单分析(一)#
牛客的课程订单分析(一)
http://www.nowcoder.com/practice/d3aa5df807f046bea5003dbc04965d67
偷懒了 懒得弄日期的标准表达
SELECT id,user_id,product_name,status,client_id,date
FROM order_info
WHERE product_name in('C++','JAVA','Python')
and status ='completed'
and day(date)>15
order by id
