计算信用卡不同逾期账龄的30天回收率
时间: 2024-02-21 12:02:16 浏览: 25
以下是计算信用卡不同逾期账龄的30天回收率的SQL语句:
```
SELECT DATEDIFF(CURDATE(), due_date) AS overdue_days, COUNT(*) AS total_accounts,
SUM(CASE WHEN paid_date IS NOT NULL AND DATEDIFF(paid_date, due_date) <= 30 THEN 1 ELSE 0 END) AS paid_within_30days,
SUM(CASE WHEN paid_date IS NULL AND DATEDIFF(CURDATE(), due_date) <= 30 THEN 1 ELSE 0 END) AS unpaid_within_30days,
SUM(CASE WHEN paid_date IS NOT NULL AND DATEDIFF(paid_date, due_date) > 30 THEN 1 ELSE 0 END) AS paid_after_30days,
SUM(CASE WHEN paid_date IS NULL AND DATEDIFF(CURDATE(), due_date) > 30 THEN 1 ELSE 0 END) AS unpaid_after_30days,
SUM(CASE WHEN paid_date IS NULL THEN amount ELSE 0 END) AS unpaid_balance
FROM credit_card_statement
WHERE card_number = 'xxxx-xxxx-xxxx-xxxx'
AND DATEDIFF(CURDATE(), due_date) <= 90
GROUP BY overdue_days;
```
说明:
以上SQL语句统计了信用卡不同逾期账龄的账户数、30天内已还账户数、30天内未还账户数、30天后已还账户数、30天后未还账户数以及未还账户的总额。其中,使用了CASE WHEN语句进行条件判断。