select substring(ObservationDate,1,7), total, count(LP.Status) as Delinquents, round((count(LP.Status)/total)*100) PCT
from LoanPerformance LP, ltotals lt
where substring(ObservationDate,1,7) = substring(odate,1,7)
and Status not in ('Current','Paid','Payoff in progress')
group by substring(ObservationDate,1,7)
+--------------------------------+-------+-------------+------+
| substring(ObservationDate,1,7) | total | Delinquents | PCT |
+--------------------------------+-------+-------------+------+
| 2006-04 | 761 | 12 | 2 |
| 2006-05 | 1374 | 45 | 3 |
| 2006-06 | 2068 | 134 | 6 |
| 2006-07 | 2921 | 274 | 9 |
| 2006-08 | 3953 | 424 | 11 |
| 2006-09 | 4799 | 578 | 12 |
| 2006-10 | 5867 | 845 | 14 |
| 2006-11 | 6906 | 1039 | 15 |
| 2006-12 | 8209 | 1386 | 17 |
| 2007-01 | 9784 | 1602 | 16 |
| 2007-02 | 10579 | 1710 | 16 |
| 2007-03 | 12675 | 2457 | 19 |
| 2007-04 | 13699 | 2735 | 20 |
| 2007-05 | 15756 | 3659 | 23 |
| 2007-06 | 15842 | 3185 | 20 |
| 2007-07 | 17481 | 3985 | 23 |
| 2007-08 | 19285 | 4786 | 25 |
| 2007-09 | 18759 | 4323 | 23 |
| 2007-10 | 20907 | 5449 | 26 |
| 2007-11 | 21723 | 5939 | 27 |
| 2007-12 | 16990 | 5143 | 30 |
+--------------------------------+-------+-------------+------+
The percentage of "delinquent" loans continues to increase;
where DELINQUENT = NOT CURRENT, NOT PAID, & NOT PAYOFF IN PROGRESS