SELECT r.region, COUNT(s.demo="USB") AS USB, COUNT(s.demo="TRB") AS TRB FROM dega.form_input AS f LEFT JOIN silver.stores AS s ON f.store_id = s.store_id LEFT JOIN silver.regions AS r ON s.region = r.region_id WHERE f.status_code_id > 1 AND FIND_IN_SET(s.region, '1,2,3,4,5') GROUP BY s.region