Sql and ASP help

[tamilselvan]

SELECT ('0 - 6 MONTHS TOTAL : ' ||(M1+F1)
||CHR(10)||'0 - 6 MONTHS FEMALE : ' ||(F1)
||CHR(10)||'0 - 6 MONTHS MALE : ' ||(M1)
||CHR(10)||'7 - 12 MONTHS TOTAL : ' ||(M2+F2)
||CHR(10)||'7 - 12 MONTHS FEMALE : ' ||(F2)
||CHR(10)||'7 - 12 MONTHS MALE : ' ||(M2)
||CHR(10)||'0 - 12 MONTHS TOTAL : ' ||(M1+M2+F1+F2)
||CHR(10)||'0 - 12 MONTHS FEMALE : ' ||(F1+F2)
||CHR(10)||'0 - 12 MONTHS MALE : ' ||(M1+M2)) FINALOUTPUT
FROM (
SELECT /*+ NO_MERGE */
( SELECT COUNT(1) FROM T1
WHERE TITLE = 'MR' AND TO_NUMBER(TO_CHAR(REGDATE,'MM')) <= 6) M1,
( SELECT COUNT(1) FROM T1
WHERE TITLE = 'MR' AND TO_NUMBER(TO_CHAR(REGDATE,'MM')) > 6) M2,
( SELECT COUNT(1) FROM T1
WHERE TITLE IN ('MS','MRS','MISS') AND TO_NUMBER(TO_CHAR(REGDATE,'MM')) <= 6) F1,
( SELECT COUNT(1) FROM T1
WHERE TITLE IN ('MS','MRS','MISS') AND TO_NUMBER(TO_CHAR(REGDATE,'MM')) > 6) F2
FROM DUAL)
/

This is my ouput from your sample data:
FINALOUTPUT
---------------------------------------
0 - 6 MONTHS TOTAL : 5
0 - 6 MONTHS FEMALE : 3
0 - 6 MONTHS MALE : 2
7 - 12 MONTHS TOTAL : 4
7 - 12 MONTHS FEMALE : 3
7 - 12 MONTHS MALE : 1
0 - 12 MONTHS TOTAL : 9
0 - 12 MONTHS FEMALE : 6
0 - 12 MONTHS MALE : 3

For ASP help, you may need to visit another web site.
Good Luck.

Tamil