mysql - 创建特定月份内的付款 list 。数据库管理系统

Question

我需要退回 2005 年 6 月至 8 月底期间的付款。但我不知道如何仅退回这些付款。我拥有的代码只是我的尝试。

/* Create a list of all the payments made in June, July and August of 2005, and, if they were for a rental, the title of that rental. */

SELECT CONCAT(payment_id,' ',amount) AS Payments
FROM payment
INNER JOIN rental
ON payment.rental_id = rental.rental_id
WHERE payment_date = 2005-06-01 - 2005-08-31;

Answer 1

尝试通过适当使用 BETWEEN 运算符来使用此代码

/* Create a list of all the payments made in June, July and August of 2005, and, if they were for a rental, the title of that rental. */

SELECT CONCAT(payment_id,' ',amount) AS Payments
FROM payment
INNER JOIN rental
ON payment.rental_id = rental.rental_id
WHERE payment_date BETWEEN '2005-06-01' AND '2005-08-31';