SELECT SUM(sellout) AS sales_cost
FROM "client_002"."sales_retailers_cost_updated"
left join "public"."retails" AS "b" ON b.id = sales_retailers_cost_updated.retail_id
WHERE sales_retailers_cost_updated.retail_id IN (12) AND
"sales_retailers_cost_updated"."sellout_date" BETWEEN '2017-01-01' AND '2017-01-31'