下面是一个示例 MySQL 查询,它根据用户输入的条件,统计上一周或本周的用户上单量:
SELECT COUNT(*) FROM orders
WHERE user_id = {user_id}
AND created_at BETWEEN
CASE
WHEN {week} = 'last' THEN DATE_SUB(CURDATE(), INTERVAL 1 WEEK)
ELSE DATE_SUB(CURDATE(), INTERVAL 0 WEEK)
END
AND
CASE
WHEN {