информация по муниципалам

Select
    count(contract_id),-- количество контрактов
    sum(nmck) nmck, -- нмцк
    sum(price_nds) contract_price -- сумма контрактов
From eshop_information2
Where flag_winner=1
and customer_id in
(44874, 13238, 13239, 13013, 34182, 33576, 12595, 12960, 13186, 13516, 12892, 39075, 12972, 29120, 13012, 13343, 15351, 18680, 18852, 13518, 41497, 42988, 12587, 13102, 13284, 12694, 12778, 16553, 17960, 18130, 38479, 12788, 37165, 256, 31545, 31546, 34161, 12584, 12607, 12608, 12690, 12777, 12797, 12810, 13010, 13097, 13194, 12697, 13118, 13160, 18630, 12818, 30884, 41072, 12679, 12598, 13525, 12789, 12723, 45688, 12606, 12611, 12678, 12680, 12682, 12825, 12859, 12888, 13002, 13217, 13372, 13464, 13605, 12593, 37109, 12590, 12665, 13293, 13147, 13667, 13444, 12624, 13108, 40269, 12744, 12774, 12719, 12806, 12826, 12721, 12831, 17923, 12663, 12718, 12592, 12785, 12751, 12816, 12791, 12792, 12800, 12802, 12832, 12715, 12822, 12780, 13459, 12617, 12696, 12786, 12747, 12594, 12801, 12839, 12720, 12745, 12799, 12807, 12787, 12824, 12758, 12766, 12804, 12626, 18493, 18678, 12796, 12782, 12795, 12828, 21171, 12808, 12798, 25195, 44547, 12717, 12588, 12591, 12601, 12604, 12609, 12614, 12615, 12616, 12622, 12623, 12630, 12632, 12634, 12635, 12639, 12642, 12643, 12645, 12651, 12655, 12656, 12638, 12641, 12662, 12674, 12667, 12670, 12672, 12675, 12664, 12676, 12684, 12689, 12691, 12693, 12698, 12705, 12706, 12711, 12712, 12714, 12722, 12724, 12727, 12728, 12732, 12733, 12734, 12735, 12738, 12741, 12742, 12759, 12760, 12761, 12762, 12773, 12776, 12779, 12784, 12793, 12813, 12811, 12819, 12827, 12829, 12838, 12618, 12625, 12652, 12687, 12699, 12783, 12631, 12707, 12688, 12708, 12709, 15769, 12640, 20116, 12628, 10883, 28471, 40676, 12683, 29617, 12658, 12654, 12713, 13196, 12755, 12603, 12596, 12619, 12726, 12668, 12834, 12812, 12644, 12633, 12737, 12814, 12757, 12775, 11632, 12763, 43382, 12637, 12835, 12671, 12600, 12585, 12794, 12740, 12809, 12769, 12739, 12681, 12725, 12736, 12649, 12661, 12815, 12837, 12710, 12729, 12730, 12673, 39973, 39974, 12586, 12597, 12599, 12610, 12620, 12621, 12636, 12646, 12647, 12657, 12659, 12660, 12669, 12695, 12716, 12731, 12746, 12752, 12764, 12765, 12790, 12803, 12805, 12817, 12820, 12821, 12823, 12833, 12836, 12692, 13349, 13993, 12748, 16807, 12677, 12589, 12612, 12627, 12629, 12648, 12650, 12666, 12700, 12701, 12703, 12704, 12749, 12750, 12754, 12756, 12770, 12771, 12685, 12686, 12768, 13127, 14902, 12702, 12830, 12753, 12781)
and date_zak>'2024-01-01'
-- информация по муниципальным заказчикам взята из отчёта 32318521 municipal_imc id что сверху взяты от туда
limit 123