SELECT ("main_retail"."created_at" AT TIME ZONE 'Asia/Bishkek')::DATE AS "created_at_date", (("main_retailitem"."price" - "main_productforretail"."cost_price") * "main_retailitem"."total_quantity") AS "income", SUM("main_retailitem"."total_quantity") AS "total_quantity" FROM "main_retail" LEFT OUTER JOIN "main_retailitem" ON ("main_retail"."id" = "main_retailitem"."retail_id") LEFT OUTER JOIN "main_productforretail" ON ("main_retailitem"."product_id" = "main_productforretail"."id") GROUP BY ("main_retail"."created_at" AT TIME ZONE 'Asia/Bishkek')::DATE, (("main_retailitem"."price" - "main_productforretail"."cost_price") * "main_retailitem"."total_quantity") ORDER BY "created_at_date" ASC