Cacher is the code snippet organizer for pro developers

-- se i valori sono null non li ritorna come risultato
SELECT 
COUNT(tbl_payment.Invoice_number) AS numero_ordini,
COUNT(tbl_payment.payment_1_date_expire) AS paga_1,
COUNT(tbl_payment.payment_2_date_expire) AS paga_2,
COUNT(tbl_payment.payment_3_date_expire) AS paga_3,
COUNT(tbl_payment.payment_4_date_expire) AS paga_4,
COUNT(tbl_payment.payment_5_date_expire) AS paga_5,
COUNT(tbl_payment.payment_6_date_expire) AS paga_6
FROM tbl_payment

---