{"id":232898,"date":"2023-01-31T13:10:00","date_gmt":"2023-01-31T10:10:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=232898"},"modified":"2023-02-07T13:21:54","modified_gmt":"2023-02-07T10:21:54","slug":"jak-za-dopomogoju-sql-stvoriti-spisok-dopisiv-jaki-otrimali-najbilshu-kilkist-golosiv-za-rik","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/uk\/jak-za-dopomogoju-sql-stvoriti-spisok-dopisiv-jaki-otrimali-najbilshu-kilkist-golosiv-za-rik\/","title":{"rendered":"\u042f\u043a \u0437\u0430 \u0434\u043e\u043f\u043e\u043c\u043e\u0433\u043e\u044e SQL \u0441\u0442\u0432\u043e\u0440\u0438\u0442\u0438 \u0441\u043f\u0438\u0441\u043e\u043a \u0434\u043e\u043f\u0438\u0441\u0456\u0432, \u044f\u043a\u0456 \u043e\u0442\u0440\u0438\u043c\u0430\u043b\u0438 \u043d\u0430\u0439\u0431\u0456\u043b\u044c\u0448\u0443 \u043a\u0456\u043b\u044c\u043a\u0456\u0441\u0442\u044c \u0433\u043e\u043b\u043e\u0441\u0456\u0432 \u0437\u0430 \u0440\u0456\u043a?"},"content":{"rendered":"\n<p><a href=\"https:\/\/helloacm.com\/how-to-get-popular-posts-of-the-year-using-sql-2015\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">\u0423 \u0446\u0456\u0439 \u043f\u0443\u0431\u043b\u0456\u043a\u0430\u0446\u0456\u0457<\/a> \u043c\u0438 \u043d\u0430\u0432\u0447\u0438\u043c\u043e\u0441\u044f \u0432\u0438\u043a\u043e\u0440\u0438\u0441\u0442\u043e\u0432\u0443\u0432\u0430\u0442\u0438 SQL \u0434\u043b\u044f \u0441\u043f\u0438\u0441\u043a\u0443 \u043d\u0430\u0439\u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u0456\u0448\u0438\u0445 \u043f\u0443\u0431\u043b\u0456\u043a\u0430\u0446\u0456\u0439 (\u0432\u0456\u0434\u043f\u043e\u0432\u0456\u0434\u043d\u043e \u0434\u043e \u043a\u0456\u043b\u044c\u043a\u043e\u0441\u0442\u0456 \u043a\u043e\u043c\u0435\u043d\u0442\u0430\u0440\u0456\u0432 \u0434\u043b\u044f \u043a\u043e\u0436\u043d\u043e\u0457 \u043f\u0443\u0431\u043b\u0456\u043a\u0430\u0446\u0456\u0457). \u0423 \u0446\u0438\u0445 \u043f\u0443\u0431\u043b\u0456\u043a\u0430\u0446\u0456\u044f\u0445 \u043c\u0438 \u043e\u0442\u0440\u0438\u043c\u0430\u0454\u043c\u043e \u0431\u0430\u0437\u043e\u0432\u0443 \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u043a\u0443 \u043f\u0443\u0431\u043b\u0456\u043a\u0430\u0446\u0456\u0439 \u0443 2016 \u0440\u043e\u0446\u0456, \u0430 \u0442\u0430\u043a\u043e\u0436 \u0434\u0456\u0437\u043d\u0430\u0454\u043c\u043e\u0441\u044f 10 \u043d\u0430\u0439\u043a\u0440\u0430\u0449\u0438\u0445 \u043f\u0443\u0431\u043b\u0456\u043a\u0430\u0446\u0456\u0439, \u0432\u0456\u0434\u0441\u043e\u0440\u0442\u043e\u0432\u0430\u043d\u0438\u0445 \u0437\u0430 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0430\u043c\u0438 \u0433\u043e\u043b\u043e\u0441\u0443\u0432\u0430\u043d\u043d\u044f.<\/p>\n<h2>\u0417\u0430\u0433\u0430\u043b\u044c\u043d\u0430 \u043a\u0456\u043b\u044c\u043a\u0456\u0441\u0442\u044c \u0434\u043e\u043f\u0438\u0441\u0456\u0432<\/h2>\n<p>\u041d\u0430 \u043e\u0441\u043d\u043e\u0432\u0456 \u0446\u044c\u043e\u0433\u043e <a href=\"https:\/\/wordpress.mediadoma.com\/uk\/jak-nadrukuvati-pidsumok-tablici-mysql-za-dopomogoju-php\/\" title=\"SQL\">SQL<\/a> :<\/p>\n<pre><code>SELECT \n\u00a0 count(1) \nFROM \n\u00a0 wp_posts\nWHERE \n\u00a0 post_type = \"post\" and \n\u00a0 post_status = \"publish\" and \n\u00a0 date_format(post_date_gmt, \"%Y\") = \"2016\"<\/code><\/pre>\n<p>\u041c\u0438 \u0437\u043d\u0430\u0454\u043c\u043e, \u0449\u043e \u0432 2016 \u0440\u043e\u0446\u0456 \u043e\u043f\u0443\u0431\u043b\u0456\u043a\u043e\u0432\u0430\u043d\u043e 245 \u043f\u0443\u0431\u043b\u0456\u043a\u0430\u0446\u0456\u0439.<\/p>\n<pre><code>+----------+\n| count(1) |\n+----------+\n| \u00a0 \u00a0 \u00a0245 |\n+----------+\n1 row in set (0.01 sec)<\/code><\/pre>\n<h2>\u0422\u043e\u043f \u043d\u0430\u0439\u0431\u0456\u043b\u044c\u0448 \u043e\u0431\u0433\u043e\u0432\u043e\u0440\u044e\u0432\u0430\u043d\u0438\u0445 \u043f\u0443\u0431\u043b\u0456\u043a\u0430\u0446\u0456\u0439<\/h2>\n<p><a href=\"https:\/\/helloacm.com\/how-to-get-popular-posts-of-the-year-using-sql-2015\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">\u0406 \u0432\u0438\u0445\u043e\u0434\u044f\u0447\u0438 \u0437 SQL<\/a>, \u0443 \u043d\u0430\u0441 \u0454 \u043d\u0430\u0439\u0431\u0456\u043b\u044c\u0448 \u043e\u0431\u0433\u043e\u0432\u043e\u0440\u044e\u0432\u0430\u043d\u0456 \u043f\u043e\u0441\u0442\u0438 \u0437\u0430 \u0446\u0435\u0439 \u0440\u0456\u043a, \u0442\u043e\u0431\u0442\u043e 2016.<\/p>\n<pre><code>SELECT \n\u00a0 post_name, post_title \nFROM \n\u00a0 wp_posts \nWHERE \n\u00a0 post_type = 'post' and \n\u00a0 post_status = 'publish' and\n\u00a0 date_format(post_date_gmt, \"%Y\") = '2016' \nORDER BY\n\u00a0comment_count DESC \nLIMIT 10<\/code><\/pre>\n<p>\u041c\u0438 \u0437\u043d\u0430\u0454\u043c\u043e 10 \u043d\u0430\u0439\u0431\u0456\u043b\u044c\u0448 \u043e\u0431\u0433\u043e\u0432\u043e\u0440\u044e\u0432\u0430\u043d\u0438\u0445 (\u044f\u043a \u043d\u0430\u0439\u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u0456\u0448\u0438\u0445) \u0434\u043e\u043f\u0438\u0441\u0456\u0432 \u0443 2016 \u0440\u043e\u0446\u0456. \u0417\u043c\u0456\u043d\u0456\u0442\u044c <strong>\u043b\u0456\u043c\u0456\u0442 10<\/strong>, \u0449\u043e\u0431 \u0434\u043e\u0437\u0432\u043e\u043b\u0438\u0442\u0438 \u0432\u0456\u0434\u043e\u0431\u0440\u0430\u0436\u0430\u0442\u0438 \u0431\u0456\u043b\u044c\u0448\u0435 \u0434\u043e\u043f\u0438\u0441\u0456\u0432, \u043d\u0430\u043f\u0440\u0438\u043a\u043b\u0430\u0434 \u043b\u0456\u043c\u0456\u0442 20.<\/p>\n<pre><code>+--------------------------------------------------------------------------------+------------------------------------------------------------------------+\n| post_name \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| post_title \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\n+--------------------------------------------------------------------------------+------------------------------------------------------------------------+\n| cc-coding-exercise-convert-a-number-to-hexadecimal \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 | C\/C++ Coding Exercise - Convert a Number to Hexadecimal? \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\n| dynamic-programming-how-many-ways-to-connect-the-pipes \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 | Dynamic Programming - How many ways to connect the pipes? \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|\n| when-xx-evaluates-to-false-in-cc \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 | When x==x Evaluates to FALSE in C\/C++? \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\n| how-to-compute-sum-of-two-integers-without-plus-and-minus-operators \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| How to Compute Sum of Two Integers without Plus+ and Minus- Operators? |\n| how-to-find-intersection-of-two-arrays-in-c \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| How to Find Intersection of Two Arrays in C++? \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\n| bit-manipulation-how-to-set-all-bits-between-i-and-j-in-n-equal-to-m-cplusplus | Bit Manipulation: How to Set All Bits Between i and j in N equal to M? |\n| how-to-check-valid-anagram-in-cc \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 | How to Check Valid Anagram in C\/C++? \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\n| c-coding-exercise-number-of-1-bits-revisited \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 | C++ Coding Exercise - Number of 1 Bits (Revisited) \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\n| dynamic-programming-integer-break \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| Dynamic Programming - Integer Break \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|\n| cc-coding-exercise-find-the-duplicate-number \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 | C\/C++ Coding Exercise - Find the Duplicate Number \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|\n+--------------------------------------------------------------------------------+------------------------------------------------------------------------+\n10 rows in set (0.01 sec)<\/code><\/pre>\n<p>\u0426\u0435 (\u043d\u0430 \u043c\u043e\u043c\u0435\u043d\u0442 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043d\u044f):<\/p>\n<ol>\n<li><a href=\"https:\/\/helloacm.com\/cc-coding-exercise-convert-a-number-to-hexadecimal\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">\u0412\u043f\u0440\u0430\u0432\u0430 \u0437 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u0443\u0432\u0430\u043d\u043d\u044f C\/C++ \u2013 \u041f\u0435\u0440\u0435\u0442\u0432\u043e\u0440\u0435\u043d\u043d\u044f \u0447\u0438\u0441\u043b\u0430 \u043d\u0430 \u0448\u0456\u0441\u0442\u043d\u0430\u0434\u0446\u044f\u0442\u043a\u043e\u0432\u0435?<\/a><\/li>\n<li><a href=\"https:\/\/helloacm.com\/dynamic-programming-how-many-ways-to-connect-the-pipes\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">\u0414\u0438\u043d\u0430\u043c\u0456\u0447\u043d\u0435 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u0443\u0432\u0430\u043d\u043d\u044f \u2013 \u0441\u043a\u0456\u043b\u044c\u043a\u0438 \u0441\u043f\u043e\u0441\u043e\u0431\u0456\u0432 \u0437&#8217;\u0454\u0434\u043d\u0430\u0442\u0438 \u0442\u0440\u0443\u0431\u0438?<\/a><\/li>\n<li><a href=\"https:\/\/helloacm.com\/when-xx-evaluates-to-false-in-cc\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">\u041a\u043e\u043b\u0438 x==x \u043c\u0430\u0454 \u0437\u043d\u0430\u0447\u0435\u043d\u043d\u044f FALSE \u0443 C\/C++?<\/a><\/li>\n<li><a href=\"https:\/\/helloacm.com\/how-to-compute-sum-of-two-integers-without-plus-and-minus-operators\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">\u042f\u043a \u043e\u0431\u0447\u0438\u0441\u043b\u0438\u0442\u0438 \u0441\u0443\u043c\u0443 \u0434\u0432\u043e\u0445 \u0446\u0456\u043b\u0438\u0445 \u0447\u0438\u0441\u0435\u043b \u0431\u0435\u0437 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0456\u0432 \u043f\u043b\u044e\u0441+ \u0456 \u043c\u0456\u043d\u0443\u0441?<\/a><\/li>\n<li><a href=\"https:\/\/helloacm.com\/how-to-find-intersection-of-two-arrays-in-c\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">\u042f\u043a \u0437\u043d\u0430\u0439\u0442\u0438 \u043f\u0435\u0440\u0435\u0442\u0438\u043d \u0434\u0432\u043e\u0445 \u043c\u0430\u0441\u0438\u0432\u0456\u0432 \u0443 C++?<\/a><\/li>\n<li><a href=\"https:\/\/helloacm.com\/bit-manipulation-how-to-set-all-bits-between-i-and-j-in-n-equal-to-m-cplusplus\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">\u041c\u0430\u043d\u0456\u043f\u0443\u043b\u044f\u0446\u0456\u044f \u0431\u0456\u0442\u0430\u043c\u0438: \u044f\u043a \u0432\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0438 \u0432\u0441\u0456 \u0431\u0456\u0442\u0438 \u043c\u0456\u0436 i \u0442\u0430 j \u0443 N \u0440\u0456\u0432\u043d\u0438\u043c\u0438 M?<\/a><\/li>\n<li><a href=\"https:\/\/helloacm.com\/how-to-check-valid-anagram-in-cc\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">\u042f\u043a \u043f\u0435\u0440\u0435\u0432\u0456\u0440\u0438\u0442\u0438 \u0434\u0456\u0439\u0441\u043d\u0443 \u0430\u043d\u0430\u0433\u0440\u0430\u043c\u0443 \u0432 C\/C++?<\/a><\/li>\n<li><a href=\"https:\/\/helloacm.com\/c-coding-exercise-number-of-1-bits-revisited\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">\u0412\u043f\u0440\u0430\u0432\u0430 \u0437 \u043a\u043e\u0434\u0443\u0432\u0430\u043d\u043d\u044f \u043d\u0430 C++ \u2013 \u043a\u0456\u043b\u044c\u043a\u0456\u0441\u0442\u044c \u0431\u0456\u0442 1 (\u043f\u043e\u0432\u0442\u043e\u0440\u043d\u043e)<\/a><\/li>\n<li><a href=\"https:\/\/helloacm.com\/dynamic-programming-integer-break\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">\u0414\u0438\u043d\u0430\u043c\u0456\u0447\u043d\u0435 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u0443\u0432\u0430\u043d\u043d\u044f \u2013 \u0440\u043e\u0437\u0431\u0438\u0442\u0442\u044f \u0446\u0456\u043b\u0438\u0445 \u0447\u0438\u0441\u0435\u043b<\/a><\/li>\n<li><a href=\"https:\/\/helloacm.com\/cc-coding-exercise-find-the-duplicate-number\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">\u0412\u043f\u0440\u0430\u0432\u0430 \u0437 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u0443\u0432\u0430\u043d\u043d\u044f C\/C++ \u2013 \u0437\u043d\u0430\u0439\u0434\u0456\u0442\u044c \u043f\u043e\u0432\u0442\u043e\u0440\u044e\u0432\u0430\u043d\u0435 \u0447\u0438\u0441\u043b\u043e<\/a><\/li>\n<\/ol>\n<h2>\u041f\u0443\u0431\u043b\u0456\u043a\u0430\u0446\u0456\u0457 \u0437 \u043d\u0430\u0439\u0431\u0456\u043b\u044c\u0448\u043e\u044e \u043a\u0456\u043b\u044c\u043a\u0456\u0441\u0442\u044e \u0433\u043e\u043b\u043e\u0441\u0456\u0432 \u0447\u0435\u0440\u0435\u0437 SQL<\/h2>\n<p>\u0422\u0435\u043f\u0435\u0440 \u043c\u0438 \u043c\u043e\u0436\u0435\u043c\u043e \u043f\u043e\u0454\u0434\u043d\u0430\u0442\u0438 \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u043a\u0443 \u0433\u043e\u043b\u043e\u0441\u0443\u0432\u0430\u043d\u043d\u044f \u0437 \u043f\u043b\u0430\u0433\u0456\u043d\u0430 <a href=\"https:\/\/wordpress.mediadoma.com\/uk\/plagin-gd-star-rating-ne-pracjuie-nalezhnim-chinom-jakshho-cloudflare-uvimkneno\/\" title=\"GD Star Rating\">GD Star Rating<\/a> Plugin \u0456 \u043e\u0442\u0440\u0438\u043c\u0430\u0442\u0438 \u0456\u043d\u0448\u0438\u0439 \u0446\u0456\u043a\u0430\u0432\u0438\u0439 \u0440\u0435\u0439\u0442\u0438\u043d\u0433.<\/p>\n<pre><code>SELECT \n\u00a0 \u00a0`p`.`ID`, \n\u00a0 \u00a0`p`.`post_title` as `title`, \n\u00a0 \u00a0`visitor_votes` + `user_votes` as `total_votes`, \n\u00a0 \u00a0`visitor_votes`, \n\u00a0 \u00a0`user_votes` \u00a0\nFROM \u00a0\n\u00a0 `wp_gdsr_data_article` as `da` \nINNER JOIN \n\u00a0 `wp_posts` as `p` ON `da`.`post_id` = `p`.`ID` \nWHERE\n\u00a0 `p`.post_type = 'post' and \n\u00a0 `p`.post_status = 'publish' and \u00a0\n\u00a0 date_format(`p`.`post_date_gmt`, \"%Y\") = '2016'\nHAVING\n\u00a0 `total_votes` &gt; 0\nORDER BY\n\u00a0 `total_votes` desc \nLIMIT 10<\/code><\/pre>\n<p>\u0426\u0435 \u0434\u0430\u0454 \u043d\u0430\u0441\u0442\u0443\u043f\u043d\u0456 10 \u043d\u0430\u0439\u0431\u0456\u043b\u044c\u0448 \u0433\u043e\u043b\u043e\u0441\u043e\u0432\u0430\u043d\u0438\u0445 \u043f\u0443\u0431\u043b\u0456\u043a\u0430\u0446\u0456\u0439 \u0440\u043e\u043a\u0443:<\/p>\n<pre><code>+------+----------------------------------------------------------------------------+-------------+---------------+------------+\n| ID \u00a0 | title \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| total_votes | visitor_votes | user_votes |\n+------+----------------------------------------------------------------------------+-------------+---------------+------------+\n| 4793 | When x==x Evaluates to FALSE in C\/C++? \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 | \u00a0 \u00a0 \u00a0 105.0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a095.0 | \u00a0 \u00a0 \u00a0 10.0 |\n| 4679 | How to Find the Maximum of Two Integers without Using Comparison Operator? | \u00a0 \u00a0 \u00a0 \u00a081.0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a081.0 | \u00a0 \u00a0 \u00a0 \u00a00.0 |\n| 4191 | How to Delete a Node from a Binary Search Tree? \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 \u00a068.0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a058.0 | \u00a0 \u00a0 \u00a0 10.0 |\n| 4380 | C++ Coding Exercise: How to Check if a Large Integer is divisible by 11? \u00a0 | \u00a0 \u00a0 \u00a0 \u00a067.0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a057.0 | \u00a0 \u00a0 \u00a0 10.0 |\n| 4329 | Microsoft Interview Question - Get the Area of the Triangle \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 \u00a066.0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a066.0 | \u00a0 \u00a0 \u00a0 \u00a00.0 |\n| 4740 | PPAP in C++ and Javascript for Beginner \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 \u00a062.0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a052.0 | \u00a0 \u00a0 \u00a0 10.0 |\n| 4166 | How to Invert a Binary Tree in C\/C++? \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 \u00a048.0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a048.0 | \u00a0 \u00a0 \u00a0 \u00a00.0 |\n| 4176 | How to Reverse Bits for 32-bit Unsigned Integer in C\/C++? \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 \u00a046.0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a046.0 | \u00a0 \u00a0 \u00a0 \u00a00.0 |\n| 4178 | C++ Coding Exercise - How to Find First Missing Number? \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 \u00a040.0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a040.0 | \u00a0 \u00a0 \u00a0 \u00a00.0 |\n| 4227 | Dynamic Programming - Integer Break \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 \u00a031.0 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a031.0 | \u00a0 \u00a0 \u00a0 \u00a00.0 |\n+------+----------------------------------------------------------------------------+-------------+---------------+------------+\n10 rows in set (0.01 sec)<\/code><\/pre>\n<ol>\n<li><a href=\"https:\/\/helloacm.com\/when-xx-evaluates-to-false-in-cc\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">\u041a\u043e\u043b\u0438 x==x \u043c\u0430\u0454 \u0437\u043d\u0430\u0447\u0435\u043d\u043d\u044f FALSE \u0443 C\/C++?<\/a><\/li>\n<li><a href=\"https:\/\/helloacm.com\/how-to-find-the-maximum-of-two-integers-without-using-comparison-operator\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">\u042f\u043a \u0437\u043d\u0430\u0439\u0442\u0438 \u043c\u0430\u043a\u0441\u0438\u043c\u0443\u043c \u0456\u0437 \u0434\u0432\u043e\u0445 \u0446\u0456\u043b\u0438\u0445 \u0447\u0438\u0441\u0435\u043b \u0431\u0435\u0437 \u0432\u0438\u043a\u043e\u0440\u0438\u0441\u0442\u0430\u043d\u043d\u044f \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0430 \u043f\u043e\u0440\u0456\u0432\u043d\u044f\u043d\u043d\u044f?<\/a><\/li>\n<li><a href=\"https:\/\/helloacm.com\/how-to-delete-a-node-from-a-binary-search-tree\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">\u042f\u043a \u0432\u0438\u0434\u0430\u043b\u0438\u0442\u0438 \u0432\u0443\u0437\u043e\u043b \u0456\u0437 \u0431\u0456\u043d\u0430\u0440\u043d\u043e\u0433\u043e \u0434\u0435\u0440\u0435\u0432\u0430 \u043f\u043e\u0448\u0443\u043a\u0443?<\/a><\/li>\n<li><a href=\"https:\/\/helloacm.com\/c-coding-exercise-how-to-check-if-a-large-integer-is-divisible-by-11\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">\u0412\u043f\u0440\u0430\u0432\u0430 \u0437 \u043a\u043e\u0434\u0443\u0432\u0430\u043d\u043d\u044f C++: \u044f\u043a \u043f\u0435\u0440\u0435\u0432\u0456\u0440\u0438\u0442\u0438, \u0447\u0438 \u0432\u0435\u043b\u0438\u043a\u0435 \u0446\u0456\u043b\u0435 \u0447\u0438\u0441\u043b\u043e \u0434\u0456\u043b\u0438\u0442\u044c\u0441\u044f \u043d\u0430 11?<\/a><\/li>\n<li><a href=\"https:\/\/helloacm.com\/microsoft-interview-question-get-the-area-of-the-triangle\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">\u0417\u0430\u043f\u0438\u0442\u0430\u043d\u043d\u044f \u043d\u0430 \u0441\u043f\u0456\u0432\u0431\u0435\u0441\u0456\u0434\u0456 Microsoft \u2013 \u043e\u0431\u0447\u0438\u0441\u043b\u0456\u0442\u044c \u043f\u043b\u043e\u0449\u0443 \u0442\u0440\u0438\u043a\u0443\u0442\u043d\u0438\u043a\u0430<\/a><\/li>\n<li><a href=\"https:\/\/helloacm.com\/ppap-in-cpp-and-javascript-for-beginner\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">PPAP \u0443 C++ \u0456 Javascript \u0434\u043b\u044f \u043f\u043e\u0447\u0430\u0442\u043a\u0456\u0432\u0446\u0456\u0432<\/a><\/li>\n<li><a href=\"https:\/\/helloacm.com\/how-to-invert-a-binary-tree-in-cc\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">\u042f\u043a \u0456\u043d\u0432\u0435\u0440\u0442\u0443\u0432\u0430\u0442\u0438 \u0431\u0456\u043d\u0430\u0440\u043d\u0435 \u0434\u0435\u0440\u0435\u0432\u043e \u0432 C\/C++?<\/a><\/li>\n<li><a href=\"https:\/\/helloacm.com\/how-to-reverse-bits-for-32-bit-unsigned-integer-in-cc\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">\u042f\u043a \u043f\u0435\u0440\u0435\u0432\u0435\u0440\u043d\u0443\u0442\u0438 \u0431\u0456\u0442\u0438 \u0434\u043b\u044f 32-\u0440\u043e\u0437\u0440\u044f\u0434\u043d\u043e\u0433\u043e \u0446\u0456\u043b\u043e\u0433\u043e \u0447\u0438\u0441\u043b\u0430 \u0431\u0435\u0437 \u0437\u043d\u0430\u043a\u0443 \u0432 C\/C++?<\/a><\/li>\n<li><a href=\"https:\/\/helloacm.com\/c-coding-exercise-how-to-find-first-missing-number\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">\u0412\u043f\u0440\u0430\u0432\u0430 \u0437 \u043a\u043e\u0434\u0443\u0432\u0430\u043d\u043d\u044f C++ \u2013 \u044f\u043a \u0437\u043d\u0430\u0439\u0442\u0438 \u043f\u0435\u0440\u0448\u0435 \u043f\u0440\u043e\u043f\u0443\u0449\u0435\u043d\u0435 \u0447\u0438\u0441\u043b\u043e?<\/a><\/li>\n<li><a href=\"https:\/\/helloacm.com\/dynamic-programming-integer-break\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">\u0414\u0438\u043d\u0430\u043c\u0456\u0447\u043d\u0435 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u0443\u0432\u0430\u043d\u043d\u044f \u2013 \u0440\u043e\u0437\u0431\u0438\u0442\u0442\u044f \u0446\u0456\u043b\u0438\u0445 \u0447\u0438\u0441\u0435\u043b<\/a><\/li>\n<\/ol>\n<p>\u0417\u0432\u0438\u0447\u0430\u0439\u043d\u043e, \u0432\u0438 \u043c\u043e\u0436\u0435\u0442\u0435 \u0437\u043c\u0456\u043d\u0438\u0442\u0438 \u043d\u0430\u0432\u0435\u0434\u0435\u043d\u0456 \u0432\u0438\u0449\u0435 \u043e\u0431\u0438\u0434\u0432\u0430 <a href=\"https:\/\/wordpress.mediadoma.com\/uk\/jak-keshuvati-vazhki-operacii-napriklad-zapiti-do-bazi-danih-u-php\/\" title=\"\u0437\u0430\u043f\u0438\u0442\u0438 SQL\">\u0437\u0430\u043f\u0438\u0442\u0438 SQL<\/a> \u0442\u0430\u043a, \u0449\u043e\u0431 \u0432\u043e\u043d\u0438 \u0434\u0430\u0432\u0430\u043b\u0438 12 \u043f\u0443\u0431\u043b\u0456\u043a\u0430\u0446\u0456\u0439, \u0442\u043e\u0431\u0442\u043e \u043e\u0434\u043d\u0443 \u043d\u0430\u0439\u043a\u0440\u0430\u0449\u0443 \u0434\u043b\u044f \u043a\u043e\u0436\u043d\u043e\u0433\u043e \u043c\u0456\u0441\u044f\u0446\u044f. \u0412\u0430\u043c \u043f\u0440\u043e\u0441\u0442\u043e \u043f\u043e\u0442\u0440\u0456\u0431\u043d\u043e \u0437\u0433\u0440\u0443\u043f\u0443\u0432\u0430\u0442\u0438 \u0437\u0430 \u043c\u0456\u0441\u044f\u0446\u044f\u043c\u0438 \u0442\u0430\u043a:<\/p>\n<pre><code>GROUP BY date_format(`p`.post_date_gmt, \"%M\")<\/code><\/pre>\n<p>\u041a\u0440\u0456\u043c \u0442\u043e\u0433\u043e, \u0432\u0438 \u043c\u043e\u0436\u0435\u0442\u0435 \u0441\u0442\u0432\u043e\u0440\u0438\u0442\u0438 <a href=\"https:\/\/wordpress.mediadoma.com\/uk\/jak-stvoriti-storinku-arhiviv-rezjume-dlja-vsih-publikacij-storinok-wordpress-za-dopomogoju-php\/\" title=\"PHP\">PHP<\/a> -\u0441\u0442\u043e\u0440\u0456\u043d\u043a\u0443, \u044f\u043a\u0430 \u043c\u0456\u0441\u0442\u0438\u0442\u044c \u043d\u0430\u0439\u043d\u043e\u0432\u0456\u0448\u0456 \u0440\u0435\u0439\u0442\u0438\u043d\u0433\u043e\u0432\u0456 \u0442\u0430\u0431\u043b\u0438\u0446\u0456 \u0434\u043b\u044f \u043f\u0443\u0431\u043b\u0456\u043a\u0430\u0446\u0456\u0439, \u0430\u043b\u0435 \u0442\u0435, \u0449\u043e \u0442\u0443\u0442 \u043f\u043e\u043a\u0430\u0437\u0430\u043d\u043e, \u0454 \u0441\u0442\u0430\u0442\u0438\u0447\u043d\u0438\u043c, \u0442\u043e\u0431\u0442\u043e \u0440\u0435\u0439\u0442\u0438\u043d\u0433\u043e\u0432\u0430 \u0442\u0430\u0431\u043b\u0438\u0446\u044f \u0441\u0442\u0432\u043e\u0440\u044e\u0454\u0442\u044c\u0441\u044f \u0442\u0430\u043a\u043e\u044e, \u044f\u043a\u043e\u044e \u0432\u043e\u043d\u0430 \u0454 \u0441\u044c\u043e\u0433\u043e\u0434\u043d\u0456.<\/p>\n<p>SQL<\/p>\n<p><div id=\"PostUnique_PostSource\" style=\"padding-top: 50px\">\u0414\u0436\u0435\u0440\u0435\u043b\u043e \u0437\u0430\u043f\u0438\u0441\u0443:  <a target=\"_blank\" rel=\"noopener nofollow\" href=\"\/\/helloacm.com\" class=\"external external_icon\">helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u042f\u043a \u0437\u0430 \u0434\u043e\u043f\u043e\u043c\u043e\u0433\u043e\u044e SQL \u0441\u0442\u0432\u043e\u0440\u0438\u0442\u0438 \u0441\u043f\u0438\u0441\u043e\u043a \u0434\u043e\u043f\u0438\u0441\u0456\u0432, \u044f\u043a\u0456 \u043e\u0442\u0440\u0438\u043c\u0430\u043b\u0438 \u043d\u0430\u0439\u0431\u0456\u043b\u044c\u0448\u0443 \u043a\u0456\u043b\u044c\u043a\u0456\u0441\u0442\u044c \u0433\u043e\u043b\u043e\u0441\u0456\u0432 \u0437\u0430 \u0440\u0456\u043a?<\/p>\n","protected":false},"author":1,"featured_media":224083,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[808,869,839,902,1000,849,923],"tags":[1174],"class_list":["post-232898","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php-10","category-wordpress-10","category-kerivnytstvo-dlia-pochatkivtsiv","category-kod-3","category-kontent-marketynh","category-pidruchnyky","category-inshyj","tag-affiai-uk"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/uk\/wp-json\/wp\/v2\/posts\/232898","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/uk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/uk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/uk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/uk\/wp-json\/wp\/v2\/comments?post=232898"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/uk\/wp-json\/wp\/v2\/posts\/232898\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/uk\/wp-json\/wp\/v2\/media\/224083"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/uk\/wp-json\/wp\/v2\/media?parent=232898"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/uk\/wp-json\/wp\/v2\/categories?post=232898"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/uk\/wp-json\/wp\/v2\/tags?post=232898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}