Clausola IF in query mySQL

[badaze]

SELECT ID, ID_CLIENTE, CASE WHEN COUNT(*) > 1 THEN 1 ELSE 0 END as Aggregati FROM `fattura` WHERE pagato=0 and pagamento like 'R.I.B.A.%' and scadenze like '%/08/%' GROUP BY ID_CLIENTE