SQL*Plus: Release 8.0.6.0.0 - Production

Dear all,

This is probably very elementary to someone more experienced, but I'm having a hard time coming up with a way to do the following:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

Oracle 11g database client 5
I am working on SQL PLUS

I have following table "table"
------------------------------- -------- ----
INVOICE_NO NOT NULL NUMBER(8)
INV_TYPE VARCHAR2(2)
AMOUNT NOT NULL NUMBER(16,4)
PAYMENT_TYPE NOT NULL NUMBER(2)
CARD_NO VARCHAR2(60)
CHECK_NO VARCHAR2(12)
ISSUE_DATE NOT NULL DATE
PROD_CODE VARCHAR2(2)
POST_DATE DATE
CONTROL_ACCOUNT VARCHAR2(12)
BAN_NO VARCHAR2(24)
-----------------------------------------------
The relevant records are as follows
INVOICE_NO INV_TYPE AMOUNT ISSUE_DATE
5 CO 10000 01-feb-2012
4 MM 12000 29-feb-2012
2 PG 6000 31-jan-2012
13 CO 130 28-jan-2012
15 TY 99000 26-jan-2012
20 CO 3400 31-jan-2012
4 PG 45 01-feb-2012
81 TY 122000 31-jan-2012
86 MM 16000 04-feb-2012
------------------------------------------------
I want this data as

select INV_TYPE,
count(invoice_no) count from table
where issue_date between '01-jan-2011' and '29-feb-2011'
group by INV_TYPE

The result comes like this
INV_TYPE count
co 3
MM 2
PG 2
TY 1
4 rows selected.
SQL>
--------------------------------------------------
I want report like this

INV_TYPE count(invoice_no) count(invoice_no
where amount >5000
----------------------------------------------------------
co 3 1
MM 2 0
PG 2 1
TY 1 0


I tried using subquery and decode and case but I have messed up.
I have thousands of records to analyse. I have to run both the queries seperately.
thanks in advance
http://stackoverflow.com/questions/ask