我有一张table在下面：

Invoice| Colour | Type

In_001 |  Red   | D  
In_001 |  Red   | D  
In_001 | Yellow | E  
In_002 |  Red   | H

我想要的结果是整理出任何发票有两个以上的项目购买和显示计数。
见下文，预期结果：

Invoice | Colour | Type | Count

In_001  |  Red   |  D   | 2  
In_001  | Yellow |  E   | 1

备注：由于只购买了一件物品，所以不包括在002中。
我尝试了以下命令：

select invoice, colour, type, count(invoice) from t   
group by invoice,colour,type   
having count(invoice)>1;

结果是：

Invoice | Colour | Type | Count

In_001  |  Red   |  D   | 2

请帮忙。