Mysql 查询最近90天数据

SELECT * FROM qs_study_user_credit_log WHERE is_valid=1 AND user_extend_id=1 
AND create_time >= DATE_SUB(CURDATE(),INTERVAL 90 DAY)
ORDER BY create_time DESC; 

MySQL DATE_SUB() 函数