How to get sum of 3 sub count queries and group them using an attribute
SELECT '2019-12-02' AS `Date`,
       SUM(cg_response_code = 0) 
     + SUM(     topup_id IN (10 , 11) 
            AND topup_cg_response_code LIKE '0'
          ) AS `Sum`
FROM XAXBXC_charge_info_ABC_tbl 
WHERE `date` = '2019-12-02'


PS. LIKE '0' condition is too strange. I'd recommend to replace it with = 0 or = '0', depending on the topup_cg_response_code datatype.


  This will work for a particular day, but I want records for each day – sadeee nadeee 2 mins ago


SELECT `date`,
       SUM(cg_response_code = 0) 
     + SUM(     topup_id IN (10 , 11) 
            AND topup_cg_response_code LIKE '0'
          ) AS `Sum`
FROM XAXBXC_charge_info_ABC_tbl
/* WHERE `date` BETWEEN @date1 AND @date2 */
GROUP BY `date`