SELECT payment_method_code FROM parties GROUP BY payment_method_code HAVING count(*)  >  3
Find the payment method code used by more than 3 parties.
SELECT payment_method_code FROM parties GROUP BY payment_method_code HAVING count ( * ) > 3
select payment_method_code from parties group by payment_method_code having count ( * ) > value
Find the payment method code used by more than 3 parties .