SELECT        sale_id, SUM(price_ru) AS price_ru
FROM            (SELECT       s.sale_id,  SUM(sd.price_ru) AS price_ru, SUM(1) AS q, ss.chrt_id, CAST(s.create_dt AS DATE) AS dt
                          FROM            Tab.Sale AS s INNER JOIN
                                                    Tab.SaleDetail AS sd ON s.sale_id = sd.sale_id INNER JOIN
                                                    Tab.Shk AS ss ON ss.shk_id = sd.shk_id
                          WHERE        (s.is_deleted = 0) AND (s.is_duplicate = 0) --and CAST(s.create_dt AS DATE)='20171110'
                          GROUP BY CAST(s.create_dt AS DATE), ss.chrt_id, s.is_deleted, s.is_duplicate, s.sale_id
                          ) AS x
                          where sale_id IN (
                          57681216,
57668335,
57676905,
57681190,
57668252,
57681193,
57668249,
57678448,
57671203,
57668315,
57676908,
57678445,
57668312,
57681213,
57678468,
57671206,
57668352,
57678465,
57668269,
57668329,
57676925,
57668232,
57668272,
57668332,
57668355,
57668246,
57681196,
57678437,
57681205,
57678351,
57668358,
57678354,
57668275,
57681202,
57668255,
57678457,
57678348,
57676911,
57668278,
57678434,
57671192,
57668338,
57668258,
57678454,
57668318,
57681199,
57668281,
57681225,
57668341,
57671195,
57676914,
57676917,
57681219,
57668238,
57668235,
57668344,
57681222,
57678451,
57668321,
57668241,
57676920,
57668350,
57678463,
57668267,
57678460,
57681208,
57668264,
57668324,
57676923,
57668330,
57668327,
57668244,
57676903,
57678443,
57668284,
57681188,
57681191,
57668247,
57678440,
57668347,
57671201,
57671198,
57668310,
57678357,
57681211,
57668261,
57671204,
57668316,
57681220,
57668313,
57676912,
57681197,
57678452,
57681217,
57668270,
57676926,
57681194,
57668233,
57678449,
57671207,
57668353,
57668273,
57668333,
57678446,
57668356,
57681214,
57678469,
57678466,
57668336,
57678346,
57676906,
57668253,
57676909,
57668250,
57668276,
57681186,
57668256,
57681223,
57668279,
57668339,
57671193,
57678438,
57668319,
57681206,
57668345,
57668236,
57668282,
57678355,
57671196,
57668342,
57676915,
57668259,
57676918,
57678349,
57668239,
57678458,
57681203,
57678352,
57668262,
57678435,
57668322,
57668242,
57678455,
57681200,
57668325,
57681226,
57678467,
57676901,
57668271,
57678441,
57668331,
57676924,
57668328,
57676927,
57681212,
57668354,
57668245,
57678358,
57676904,
57678464,
57681209,
57668248,
57671202,
57668348,
57676907,
57678461,
57671199,
57668311,
57668351,
57671205,
57681215,
57676921,
57681189,
57668268,
57678444,
57668265,
57678447,
57681192,
57668320,
57681201,
57678347,
57668237,
57668234,
57678433,
57678453,
57668274,
57668334,
57681221,
57668357,
57681198,
57671191,
57668254,
57681218,
57668314,
57668251,
57676910,
57668277,
57678450,
57668337,
57681195,
57668257,
57668317,
57678350,
57676913,
57678470,
57668340,
57678456,
57668346,
57671200,
57668343,
57671197,
57681227,
57668260,
57676916,
57676919,
57668349,
57668240,
57678442,
57681187,
57668263,
57681224,
57668323,
57668243,
57678439,
57676922,
57668266,
57681210,
57668326,
57678356,
57676902,
57678462,
57678459,
57681204,
57668283,
57678353,
57668280,
57681207,
57671194,
57678436)
GROUP BY x.sale_id