Party name According how many invoice to Show count , But Not Show count Total Invoice

[krunal123]

Show Result : 3 (Pleased Show this Query........................................)

 

[C Moore]

Add a column for distinct count of invoice no. Its asking how many invoices have the party name as SAIND, then asks how many different party names there are (all SAIND) so one.