Someone
public text v1 · immutableSELECT
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