보고서를 출력하고자 합니다.
해당월에 구간별 연체 분포를 알려고 하는 보고서 입니다.
구 분 | 0-49 | 50-99 | ....
원금 | 1개월이하
2개월이하
3개월이하
1년이하
합계
이자 | 1개월이하
:
>delay_term : 연체기간(1:1개월이하,2:2개월이하....)
>delay_amt : 원금
>delay_int : 이자
다음과 같이 질의어를 만들었는데 너무 초보적인것 같아서
도움을 요청합니다.
제발 고수님께서 멋진 질의어를 만들어 주시길...
select '1',delay_term, sum(delay_amt) AMT, sum(delay_int) INT
from loansm
where app_month = '200202'
and as_value between 0 and 49 //구간
group by delay_term
union
select '2',delay_term, sum(delay_amt) AMT, sum(delay_int) INT
from loansm
where app_month = '200202'
and as_value between 50 and 99
group by delay_term
union
select '3', delay_term, sum(delay_amt) AMT, sum(delay_int) INT
from loansm
where app_month = '200202'
and as_value between 100 and 149
group by delay_term
union
select '4',delay_term, sum(delay_amt) AMT, sum(delay_int) INT
from loansm
where app_month = '200202'
and as_value between 150 and 199
group by delay_term
union
select '5',delay_term, sum(delay_amt) AMT, sum(delay_int) INT
from loansm
where app_month = '200202'
and as_value between 200 and 249
group by delay_term
union
select '6', delay_term, sum(delay_amt) AMT, sum(delay_int) INT
from loansm
where app_month = '200202'
and as_value between 250 and 299
group by delay_termselect '1',delay_term, sum(delay_amt) AMT, sum(delay_int) INT
from loansm
where app_month = '200202'
and as_value between 300 and 349
group by delay_term
:
:
|