mysql年初至今聚合

时间:2024-07-16 23:07:08

年初至今聚合和滑动聚合类似,不同的地方仅在于统计的仅为当前一年的聚合。唯一的区别体现在下限的开始位置上。在年初至今的问题中,下限为该年的第一天,而滑动聚合的下限为N个月的第一天。因此,年初至今的问题的解决方案如下图所示,得到的结果

SELECT
a.empid,
DATE_FORMAT(a.ordermonth, '%Y-%m') AS ordermonth,
a.qty AS thismonth,
SUM(b.qty) AS total,
CAST(AVG(b.qty) AS DECIMAL(5,2)) AS avg
FROM emporders a
INNER JOIN emporders b
ON a.empid=b.empid
AND b.ordermonth >= DATE_FORMAT(a.ordermonth, '%Y-01-01')
AND b.ordermonth <= a.ordermonth
AND DATE_FORMAT(b.ordermonth,'%Y')='2015'
GROUP BY a.empid,a.ordermonth,a.qty
ORDER BY a.empid,a.ordermonth
运行结果如下
aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAV0AAAETCAIAAAAauEL8AAAgAElEQVR4nO1dy27cSJblVxkCv8C/MXKBC32Ft5XlBrirbxC6XSVjAH5AbbQctO32JoHph3u6Z+BFq6ptyXapcGdBMngZN+KKKSWD94TigDDSkRR5TjLjZATJe1j9/uV/lqUsZSkLX6rfv/xPKigoKGBA8oVffvllawqbIXvtiAIROetwioovYCB77YgCETnrgPSFn3/+eWsKmyF77YgCETnrcIqKL2Age+2IAhE56yi+AIbstSMKROSsw7Yv7Nu6bvei+erq6ujbXAUr7OtB2iVSfhrLdndkgcfFGl9Ik3CKDPiC/NAjh+Ff//rXMfdydLhdrLCvB2l3UBiu8fkc8oEcR+BCPoe+u8YX0iScosEXfv319ubzVyvLn353cvK7t/PG29vf/vm//3d/nqFtrkX72Pt6qPb1GT5wd0cTuJDPoe+u8YW0t/SKrm++XN98GXzh66+3/f/vv7x9cVL1ONm9/XL99sXJyTenJ1VVVacX73bDi1k7a3nxZraFqupb2HJ7+9v//OOfAZ7TX31zcTNsbfeM/dfbZoDnuH6Ms7YXt86wflVVJ8++Ee8+aIlqP2xRGY5H4c13bqUXb1J9IEcSuFj+d+98/vN3pw+BfUmWfiE3WgKcB2lfrm9enca6g1DUvz6WL4w7Hr8ib96+OOn5XXxTuRe8/aZ/q++NL97cvDrl37nFh8H91ZvvTqpnr3rl4zdPbjPIk3/XQ5zZdgJ7GdbxDc5/9wHL0b6CCsPp0xg+n4tn31yk+kAS9bHpeyX4R7511xffDOrM+4LP+ebLxTP2mT97FeoOAUX969EXvv766frz/Zc3zIeqqqqe/fjmxcnJi9f9W/yF++/150/Xr06rk92FaJ+tMyy3v/32/u//kDxnf8X3623H7T3GU1INclb2Il9EtBy6xLTf5zDFGA4tr077jyXtB3I0gfeT3+v1G6ff1dcbcj5IHed8/fnTxbPq9NWn688/np7s3iw9Cv3r4/mCtxuzvhDjuZBz5r7gjstic8/PF968OKlOdm/Ur401X5Ccrz9/uv7T7uTZj9evTp1NHOoLX77++vHTzQOWi9OqOv2Rtbz+7snJd6/lC/ffTzcff3xWTS0Xp9XJt69vPn66eb07qdw643J7+9tf//Z3ydPt9/XupDq9+Mi3H9hmnKfCmf1VYC985erZD7FtPmCJaT94URiO/57u3n78dPPx09tvT06+/THRB3I0gQvlS/4RtsPXZkPOy6V5nMfXp6fPngzHdOoOylHoXw++8PnL139/vH7Q8nr3xA1jnuz++Hr35Mnuj307f8FXq05/4Cv8cDr89enp0MKW29vf/vLX9wGe0wbnW+sXuc0YT0nVexHbC3vd723G3+NzryWq/fAlynDgefEf7rP59k2yD+SIAhfJ76Vx/vN3x2/NyHxTzgdJC3zaTKDrDsOXP6Sof308X1i43LefWDsMKZfstSMKROQ8LT+cVqcXQUX969EXPn/95d+fUix/3D15svuvw//w9vb2z3/5WzqelpbstSMKROT8BzcarE7/EFHUvx584ebzl59/+Wh5+fX29r///Ff7PIv2RyIQkfMSRf3rwRf+VFBQUDDC3QcNgK9fv25NYTNkrx1RICJnHU6RgbqpxcivfG05steOKBCRsw5L9ZSLkd9hWI7stSMKROSso/gCGLLXjigQkbOO4gtgyF47okBEzjqKL4Ahe+2IAhE567DuC01Nh8VmfWjr51X1vKqeV/VP/Z92zdDSdLNVu+Z7l73j1qmq53X7wdvoki0kAuRXsKOqoqqiuh0ammpoqSryPkErAjt6WtHTis5GzrtqaHla0bkFzocw5O9exlsc7PrCvqWqoupQX3jXNO/6V13zvG4/UPey6lv2P9XVy6Ff73+qq+dVNfMFr89PWLaFRLDSbZajo6oi77NtRIuDCYFdoLfsQv2nxwacD2R42dCuIyJ639LTJtzCYdcXiIj2VB/qC+yP2+/r9gPr8B/amnfj2X8VX1i4hUQw0W0OQdf4IwIy7wuXTfj31o4vHMpwemtPZzW9D7Vw5OsLQ6flHX7e+X1f8GYfDgu3kAgWus1B4FMG99m5RjezcLAgkA/Id53feGaA86EMd/Ppw2WohSNXXxgmEYf36uEPh2nC86r+qS2+8BBMQ4M91aEJhcHzC7Pf0tBwffPzC4cyLL5AzBTo8FlAP/vwtlbmEfcHnzK0te8CssWCQN5Pzmu/j8mWLX1hGcNHP4/40NbzCwrBs4bDmq5Xu7OVH9panGhYtIVUsNBtDkLXjJMFN17oxglFaARhQeBlMw7F3a9xNw7XQ7/Pm5xfuJsho5rPecfhesR8XtpDOQxu/M9OFgSuMvLVmnezq5vj5QyOBVtIBQvd5lC09fyS5J7qyJElMwLP6/kFvz2difm8wyac72Y4t7BMrlMqMPLV2QTZa0cUiMhZR/EFMGSvHVEgImcdxRfAkL12RIGInHUUXwBD9toRBSJy1uH7wlVBQUFBGS9gIXvtiAIROesovgCG7LUjCkTkrKP4Ahiy144oEJGzjuILYMheO6JARM46ii+AIXvtiAIROeuw7gtG85oCe0kE419Bfvd6VVHFbrzvGj9lR7bQJgLZHcSu3Oh+dw2vjcuGno41TjE+fB0OmeYEeR+06bwmsZdkMO4LHFPFVP+6mVXByZYe6QVO1Yfd0KNkTdF5PRYddIFel4bzZUNnzVD7GKt64ut48IqpUeumiMznNU17WUDnSIDxBVYruW+pbmdHU7Y4bOkL8RrkhWkF6+F9S2ftHVXS3joePNqPrM7aIUFek7+RFEDxBTdYGCyApqMpWzg2EbgTA2yZYuKmGOnzF4YOT5pPyXU8eGlOjzCXhRLlNSWfRBCKL7DBgiuyHpaaGtHCkV6gG1Gf18OIOtBn2DkIOSFfm7MrqR6W2i+gvgytI63BrX++f4y+kCavaQNTIBBf4GcWJsijaWG8MP917ccC2hhbHXWvjiVpS5HxgsPdGjP0hTR5TWIvyQDgC6EUpqHdoC8Q7USQiXJO7rzeNPd1f8d5R77OLJdFpDmhnne0nNcU2ksi2PeFtg4NFsiuLyy6Tike4sKR3hcCDOU63BdCeVOQ1ykV2O8b6yF77YgCETnrKL4Ahuy1IwpE5Kyj+AIYsteOKBCRs47iC2DIXjuiQETOOnxfOCjRpaCgIFfMfAECV9nZ83Jkrx1RICJnHcUXwJC9dkSBiJx1FF8AQ/baEQUictZRfAEM2WtHFIjIWUfxBTBkrx1RICJnHdZ9wWheE1//ZaAUYD0gfgUbVj3Zf+KyxWEDgaH7oGM3PgfTkFbnzBjyx1jHnlt7HrovP5Pn1oLkNZVclrvRiDIq2eKQXqDMa+pNQfaWWBrS6py7WVHD+T7AOaBizjyT59wTQeQ1aYayBoovHB0yr+myCfzkKmlIKTn3bCVn2cKhJVA9ijprh9Xzmvbt93JusjpAfaGfMrg6S9nisIlAmdf0dF59qKchpeMcqqeUNaDS1IIJVI8tl4VS5TXxHSUCoi84NOJsgmxJL1DLaxpLlWUa0iacXZyc5CxbvD8svpAmr2l8+2UwsmEtQPtCW/suIFtSC9TzmmSa43bjhV0Vnimc13TeBVR4f/u45xFJ8pr2PzXMd8p4QUU3xuq4HCfZwpBeYDCviZ/2n/2WbuILezqbzw4kZ9nCyedz3tFyXhO9aypt/RWB5wt7qr3jKFsYjFyndBMHf66+hS+8b2ezmOH0553XKfd+PGwO1ykV4PWN4yF77YgCETnrKL4Ahuy1IwpE5Kyj+AIYsteOKBCRs47iC2DIXjuiQETOOnxfOCjRpaCgIFfMfAECV9nZ83Jkrx1RICJnHcUXwJC9dkSBiJx1FF8AQ/baEQUictZRfAEM2WtHFIjIWUfxBTBkrx1RICJnHdZ9wWpe0/jGSx7ukgLWv4LsHue6jbQQUbd9nfWO3c685B7hJXcNrwWR1+TdGf20CWU6zcGLx71ycqT7oE3nNY3t9csmVJS5Iqz7QjeVPAw11KGWatNclqFTjb4gK4jO67EGacw+WlhltBZEXhPHUOWlrkOimBq1borIdF7T/qe6/mkfKdZeEdZ9gSFWVd01fjtHIoHzgJNoDbJMK7CR1zRBVnyG6qxJ+MIjq7N2WDOvaTAFfyMpAOML8tiNLTz0dbN6yqAvMBfghZVeIoOSYrI6RB+eSsLj6/TYzWcZjzCXhVbOa+oT3NiS0BpQfEGJZprCHTfMX1B9gc/Vnx6SbrQ2/AlCaLAQnETIFR6hLyTMayrjhRD0vDYe+rpZXpM6j5CrWZhHRM8sqOtI+COgRzGPSJLXFN5IElj3hT3VnimIlq6ZXarYfLygnIE7r4eOt/F5R5HX5BovlXX4Cl0gkwryvKPpvCaH4gtz8KPWX4aULUTU1uGHylDK6xEs7tm/Yhd6qMyG1ykDeU3Ms6LrcF9gMyN+2QLvOqUC431jVWSvHVEgImcdxRfAkL12RIGInHUUXwBD9toRBSJy1lF8AQzZa0cUiMhZh+8LByW6FBQU5IqZL0DgKjt7Xo7stSMKROSso/gCGLLXjigQkbOO4gtgyF47okBEzjqKL4Ahe+2IAhE56yi+AIbstSMKROSsw7ovWM1r0tdfEShfQX7gpsLq/j58luC0yX3QPaa8Jpl0pLbIwqTVOcezmC6bKWBGJjLNIG7uhrwP2nZek7b+qrDvC/6BY3lNffXkVEPZBY5vAoFeXlMg6Ui0TEknHfvDZJwjWUyXDZ014YJxuQWv/6PWTRFZzmsqvqAicuD6CuvJF0KrJRIYCS+RSUd9y9RuJq/pfTsWRy3whcvG1/XI6qwd1sxrUtdfF6C+0BdQug+/2XweEfSFeP4CsVH3BvMIwWcwhQhDmfvKpxiuhPSx5bLQynlNwR0lAqgv9OjTWbpmmFm09XjGgWFDX5ChJq7FjbrP6y3yFwSf83qeBz3XEhTCC66XJ1Dl5AsJ85oC668LaF/oGmra2VsW8pp6KKbgrSznGmk4h7OYQgYnGfKeX/KaiFbKa1LXXxVwvrBvZwlu7Z4aF7RjI68plnTEW3aVn3fEkeZ6RDigzQkRiUyc6pT4VvKaVsxrumP9FWHfF/wD14njuPV1Si+vSSYdxbKPtjq/EMxrGuB8QSYyzS3MTT0cf8jrlArs9431kL12RIGInHUUXwBD9toRBSJy1lF8AQzZa0cUiMhZR/EFMGSvHVEgImcdvi8clOhSUFCQK2a+AIGr7Ox5ObLXjigQkbOO4gtgyF47okBEzjqKL4Ahe+2IAhE56yi+AIbstSMKROSso/gCGLLXjigQkbMO675gNa+J6F1T6qwVdM0smoU/tJbfB12LiuBkAne8WGhBltGGz609KD9qF8qVIPI1evdWeyUSdn3BdF7TuybwbOskgPCFrqG6GUunulnyAtEswakRJRIJBMq8Jq+3n9djicGYzrTxc+6X5Uf5uuZbCDpaj6mqaoRdXyCym9fUvUxaW81h3xf2LdXtdOy6JlAc5WChzlrLMhpfL6xKToA78qMiOVRS4wS1QjQ7X1gxr4lPOko95QyDKdB07KbQV1EXayTHLZhl5HqRn1agppisjjvzoyK+IDU6yMEC5esLq+Y1zUcQJX+Boc9rm5aaJSyItAU5iaCNfMHLMuKz96eHpButjbvzo+K+4GsM/ndElr6wdl4T95eS1xQBGy84L+CzhqAp0La+IJOOxtUszCMW5Ufd6Qvz9YODBcrQF5LkNXUvx+lGGS/EwM4v8MsQ3fgidtJhk/MLXpaRw3k9vLXxecfl+VEihyqW1xT4Wwa7vmA6r4n27fcbPFSGAH2B2OSi9wJ+ZOWlynTXI9hk288yEpctadPrlAvzo3xdd+U1OdeTsOsLCmD6xgrIXjuiQETOOoovgCF77YgCETnrKL4Ahuy1IwpE5Kyj+AIYsteOKBCRsw7fFw5KdCkoKMgVM1+AwFV29rwc2WtHFIjIWUfxBTBkrx1RICJnHcUXwJC9dkSBiJx1FF8AQ/baEQUictZRfAEM2WtHFIjIWYd1X7CZ1+TdbT0ru1gZ9r+CU2F1QyTueq5YccEs02nE6gJl9lHwHufQrdBEdNkEgk+scI4zDOc7RTSSZV8wndc0fzdllJt1X2BZTDJzZaqh8jKdGFYXKLKPAjVRkXSjy4bOmi3qKUN5TV6ilM4wkO+kJjjZ9QUiu3lNE0o9ZRyNF9/G8he8TCeOlAL9zJWxGDGYbvS+HQuWDOQ1BfMgFIYy30lLcMrZF1bMa2LvpR0sEIgv9AWUfrn6OFiQmU4c6QTKbAWW2uYVXA5djrb2BcbZS5TSGZLId1ISnChfX1g1r4ltIXn6K4Qv9Jglr7DBgsx04kgmcMd6iJbmWNElK1Ielq05y0QpyZBbg8x3iiY4EVGmvrB2XtP4RvLBAkH5QtcQM9RAJPyG4wX+eyvnEUsSnDjSc9b43NUiZyK+xgx9IUleU2zNBDDuC/s2lNQmkh3HtbfwBZF9JM87KglO2/iC4OwQyFZxDBl5me+kabTsC/bzmtIPFsi8L7hHyPCj1tahwQJt4wuB7KPQNT+ZbuQ4p/eFAOf4JcagLwSvU0Y1WvYFBdb7xprIXjuiQETOOoovgCF77YgCETnrKL4Ahuy1IwpE5Kyj+AIYsteOKBCRsw7fFw5KdCkoKMgVM1+AwFV29rwc2WtHFIjIWUfxBTBkrx1RICJnHcUXwJC9dkSBiJx1FF8AQ/baEQUictZRfAEM2WtHFIjIWYd1X7CZ18T2Up5bK9D5D6T1Epz6cgn+JFuO1QWK7CPvLmNXbji7MzqUmJSOMy+LbsItQRUOukZ5K7RdXzCc18RqLt81VaAoc0VY94VOJC+IBKcpx6nbIsdNZB9x9NVEwQQn5a9Sch5qH2ULw1QTFYJ7d1fymoiOmNfEfCFcrL0ijPtC1wSGAA59gtPkCzbymiaMhUay8lr7q7ScZWf2W0L1kcF3H6UvrJvX5NYv84gZmipcBeslODUbziMcRJ8P/pAGet1G+Qt9+eOl2kKLBwvE5hFIua9EdvOaxpnFvv0+aRg0IfjCOFULZC70iQwur6WtZ/HQPZIJ9KcDkR9SzxeC4SiJxwsegVnL4sGCvs0sfWHlvKbZH8r11wWML0TyoJt2dkzlOmkExs4suHeD84hwYlLag+LOfQRblg8WOEpe01HymrrGxbeUPOg5pry2cbwgE5waN8UIjSnSXI8IpK2wH9LAecd4YhIlyWXhqXN9yqvX4khOwwH9v52f4MRh1xdM5zWV65RxuFjX6aKDdxw3vU4ZzGuSaWjedcrgXyXj7NKZpuxm2SJVzDt88F3MPOgI7PeN9ZC9dkSBiJx1FF8AQ/baEQUictZRfAEM2WtHFIjIWUfxBTBkrx1RICJnHb4vHJToUlBQkCtmvgCBq+zseTmy144oEJGzjuILYMheO6JARM46ii+AIXvtiAIROesovgCG7LUjCkTkrKP4Ahiy144oEJGzDuu+YDSvKbrN1YH4FXRV1X7hSbNFLsv98ppIe1RsgoMi85qG9nlZl8+Zo7tbtYNdX7Cd1zSWUZS8prvQ1mNZxDydqWuobrbIZVmQ13ReszKEvuN18f62SV6T69ijLwRqveZbUPjLOku7vkBkNq8pnumwPuB8oZnHsQyVUy3VLUJe0/j6sokWU9KGeU2sDFzPmNL4Y9VTEpnNa+L5DiV/4Q40rGiyT1sYTIG29gU1r8n1ot47eESqUn24KgLpTEFfiGS9xfgHQxly9YV185r4WYzEpxjgfIFXVVdjvmPFWqp6tnoygUpeEz8H8VQmPsZ/XRPAT2da7Ath/pEEpyx9YeW8Jv5myX1dDnk0txsv6HlNE8aOt5sHGWyY+zrLa1o8j4jxjyU4ZecLKfKaJn7t93LesS5wfaGtpydKDNjEFxbkNTm4LJOp/2wxXginM9HMAmIZU5fjuwH+8TBIu75gOq/pXRM5GbE68HxBPGZmwha+sCivKXRJsp/ey0ewJOAcTGfiQvrG4LNw+DDB4y9Tqhzs+oICvL5xPGSvHVEgImcdxRfAkL12RIGInHUUXwBD9toRBSJy1lF8AQzZa0cUiMhZh+8LByW6FBQU5IqZL0DgKjt7Xo7stSMKROSso/gCGLLXjigQkbOO4gtgyF47okBEzjqKL4Ahe+2IAhE56yi+AIbstSMKROSsw7ov2MhrUtYveU0C4sZnl9dUzfNCDj64R0Is++iyGWNOlmU6GefMsTSTaoRdX7CT1yTXj1dSrQ7rvtCJvLZuKm/p8xfo3gf3SAxl9hH1lUXNWIa0INOJwz5njp6/nu9k1xeIjOQ1yfXVyuuVYdwXuibw6HoHnt30sIN7HLjq4/ctnbXhCuVYphOHdc4cMpMqtIV8feFoeU1y/ZLjFkVThatg+yyW2Qe1qS/w7KOhg1Goh8QznTiMc+bgmVRKjkuuvnDEvKa9WL/4QhTTiGBPtQiA5pluRsYL5/upAHlY5gnLdw4WyDhnDsb/EfrCcfOa5PplHhEFnym4swkOXcMGEQZ8YZZ9RP4v7dJMJ9ucvb91/B/ZPGKFvCa5fjnvGEPXsEzXijqifTu5g4XxQjT7iFgPOSTTicxyVqMcUc87WsprEuuX65RxuFjX0UQDx/F+B/c4CGUfjbSGPrYo08k+Z5HX5PGHvE6pwH7fWA/Za0cUiMhZR/EFMGSvHVEgImcdxRfAkL12RIGInHUUXwBD9toRBSJy1uH7wkGJLgUFBbli5gsQuMrOnpcje+2IAhE56yi+AIbstSMKROSso/gCGLLXjigQkbOO4gtgyF47okBEzjqKL4Ahe+2IAhE567DuC1bzmmItqwPgK7g4r6lrAtEsyQROSUfBO4JDj64lol2ohDkB50Bek2Co3Nc8bcfxZ/lOypN4zfmC5bymYEsaWPeFZXlN1FdYNVs8556I5klHgQqiLtC7hgKETXxB5jUJhuf1uE4XJunxn7JbQuvb9QUis3lN8Zb1YdwXFuY17Vuq222ec08i6UhWHF82kWrlSORJyoPSs5UM9TyFAYz/5AuPos7aYcW8pnjL+jDuC0vymgZToG18QSYdyR61qyL1i5v6As9rkgx5/XU0x02ENeDNI4jM5jXpW1gX9n3hzrwmV4g9LPVsnbUFyqSjs5AvTCMIL8LAwHjhfB9iyM4XRE8xMP5u9nReQ+UvEJnNa9K3sC5gfOHOvCbabB7h9h6bR+zmsQXTz6kBX+j7c5QhqfmOPMSFrSPHF9n5QpK8pmjL+jDuCwfkNZEVX5DnHae8MxvjBZnXFGXI81dkwBTjv3NTJDXh2pwv2M5rCrSkgXFfoGV5TQNs+AKFrvC56YbrkDwQabf4C3kchPKafIbywuq8w/v8Qa9TKrDfN9ZD9toRBSJy1lF8AQzZa0cUiMhZR/EFMGSvHVEgImcdxRfAkL12RIGInHX4vnBQoktBQUGumPkCBK6ys+flyF47okBEzjqKL4Ahe+2IAhE56yi+AIbstSMKROSso/gCGLLXjigQkbOO4gtgyF47okBEzjqs+4LRvKbAXhIB5SvIs5hc8XUXX8chmUCe1xRoiachyRuHE3D28pq8p9Q+bWb3NQefr+vf6w16H7TpvCaxl2SA8AWexeRqKPftLMfNTl5ToCWU1xQNO9kkr4lhqKFi6+xEV5e1YSWvabW8pmkvC+gcCfZ9wctimiUyjEfTVF6TbAnmNW3pCwqNUDWk9A5ZS17ymlbLa4o1rgnjviCzmHgiQzNWXpvKawomOMn6xV18lJ7moPC8Joep4Noh1M+DKW8lr8k1HjWvKfkkgsz7gsxiqoUvWMtr2ikJTqFfYzlKTzxemOXELKBHIV8oeU0r5TVtYApk3hcmqPMIirVslL/gtWhpSGq6UQK4/kyhwULQFEjOI0pe0yp5TWIvyQDnC7HzjnwdDgu+EEhD6halG60EmdcUYLKns0oEuo0ryPOOJa/p+HlNob0kApwvUPw6pVlfIJmGxK7q7cTvRoLrEcG8Jj5Y8K5cDqdR59OHHK5TKoDpGysge+2IAhE56yi+AIbstSMKROSso/gCGLLXjigQkbOO4gtgyF47okBEzjp8Xzgo0aWgoCBXzHwBAlfZ2fNyZK8dUSAiZx3FF8CQvXZEgYicdRRfAEP22hEFInLWUXwBDNlrRxSIyFlH8QUwZK8dUSAiZx1WfWFP9XjzbH1QWesqeU1LtpAIKF9BmcUko7cODuNaGTLBaScLljd9zv29GVLo2byyxcGqL3RTTYT/cPTkeU3LtpAIEL7gZTHJ6K17hnGtCS/BaSg3YH1Mtjik4fwQhrJuSrZwWPUFhrY+xBcmHCuv6dBK7XVh3xfCWUzLiqxpI4EywYnojsIqjgScH8hQ5jXJFg7zvnDvkruj5TUdmuyyLoz7QjSLybAvyLymAWZ84eEMZS5LMMHJwbovyEkEpc5raosvLIfMYho+H8O+IBOc3o8MjfjCwxlm5QtBU6DUeU1lHnEv4IwXJlgdL0QJPLp5xJ7qiClQ8rymRVtIheILKyIzX1DzmiDPO/KwJnmpUjkM6+Q1LdhCKiD6gozeul8Y1+qYJ8d7EUmyxWETX7iboZ7XBHmdUgVM31gB2WtHFIjIWUfxBTBkrx1RICJnHcUXwJC9dkSBiJx1FF8AQ/baEQUictbh+8JBiS4FBQW5YuYLELjKzp6XI3vtiAIROesovgCG7LUjCkTkrKP4Ahiy144oEJGzjuILYMheO6JARM46ii+AIXvtiAIROeuw6gvG85oCe0kE419B7wZ2/gBrnuDUsHXuFa5xBOhJRztWvzg81nV8eOzZQV/II8Hj4z2l9mlzx3NoKZP7oI3nNYm9JINxX+DomsnTvQSnRj7bekQCgUuSjvzS4y7cf3qk8YXY3i8bOmvpvGb+JSwvk7opDrt5TdNeFtA5EmB8YU/12PllgtO2vtDT02slvX542ZM3AK4AAAFYSURBVIR/hHts6QtjcdTkC6Giz1zqrB0s5zX5G0kBFF9wg4VgglNzv0niEbHAF/isgQ/jd8LSUs4jvFlMP1jw1pEWllUuCxnPa0o+iSAUX2CDhWiCExEdOkk8KsPliSbn+/mva7wXJcCOd/tQwsJ5HZgXZOULtvOaNjAFAvEFfmZhQmjod99J4oOx2Bf68TnvOdOIfUTKg8L3Pg0W5uQlw1zmEcbzmsRekgHAF9hgwW/vfcGdVA6tacIXunGyMP4gz3pg+vGC4COZ7CqxTslrmv4wSV5TaC+JYN8X2jo0WCDmC+witDzZm+56xF1JR97ZBBe+Kmfvq3OO8Jmda5DXKUte0+NB9toRBSJy1lF8AQzZa0cUiMhZR/EFMGSvHVEgImcdxRfAkL12RIGInHX4vnBQoktBQUGumPkCBK6ys+flyF47okBEzjqKL4Ahe+2IAhE563CK/h+wvMWZfP8NIwAAAABJRU5ErkJggg==" alt="" />