{"id":521312,"date":"2026-07-22T21:28:00","date_gmt":"2026-07-22T21:28:00","guid":{"rendered":"https:\/\/livelycity.com\/switzerland\/query-c%d0%bf%d1%80%d0%b0%d0%b2%d0%ba%d0%b0-%d1%80%d0%b5%d0%b4%d0%b0%d0%ba%d1%82%d0%be%d1%80%d1%8b-google-%d0%b4%d0%be%d0%ba%d1%83%d0%bc%d0%b5%d0%bd%d1%82%d0%be%d0%b2\/"},"modified":"2026-07-22T21:28:00","modified_gmt":"2026-07-22T21:28:00","slug":"query-c%d0%bf%d1%80%d0%b0%d0%b2%d0%ba%d0%b0-%d1%80%d0%b5%d0%b4%d0%b0%d0%ba%d1%82%d0%be%d1%80%d1%8b-google-%d0%b4%d0%be%d0%ba%d1%83%d0%bc%d0%b5%d0%bd%d1%82%d0%be%d0%b2","status":"publish","type":"post","link":"https:\/\/livelycity.com\/switzerland\/query-c%d0%bf%d1%80%d0%b0%d0%b2%d0%ba%d0%b0-%d1%80%d0%b5%d0%b4%d0%b0%d0%ba%d1%82%d0%be%d1%80%d1%8b-google-%d0%b4%d0%be%d0%ba%d1%83%d0%bc%d0%b5%d0%bd%d1%82%d0%be%d0%b2\/","title":{"rendered":"QUERY &#8211; C\u043f\u0440\u0430\u0432\u043a\u0430 &#8211; \u0420\u0435\u0434\u0430\u043a\u0442\u043e\u0440\u044b Google \u0414\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u043e\u0432"},"content":{"rendered":"<p>QUERY \u0412\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u043d\u0430 \u0431\u0430\u0437\u0435 \u044f\u0437\u044b\u043a\u0430 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 API \u0432\u0438\u0437\u0443\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 Google. \u041f\u0440\u0438\u043c\u0435\u0440 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f QUERY (A2:E6; &#8220;select avg (A) pivot B&#8221;) QUERY (A2:E6; F2; \u041b\u041e\u0416\u042c) \u0421\u0438\u043d\u0442\u0430\u043a\u0441\u0438\u0441 QUERY (\u0434\u0430\u043d\u043d\u044b\u0435; \u0437\u0430\u043f\u0440\u043e\u0441; [\u0437\u0430\u0433\u043e\u043b\u043e\u0432\u043a\u0438])<\/p>\n<p><a href=\"https:\/\/support.google.com\/docs\/answer\/3093343?hl=ru\" target=\"_blank\" class=\"\">https:\/\/support.google.com\/docs\/answer\/3093343?hl=ru<\/a>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>QUERY \u0412\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u043d\u0430 \u0431\u0430\u0437\u0435 \u044f\u0437\u044b\u043a\u0430 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 API \u0432\u0438\u0437\u0443\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 Google. \u041f\u0440\u0438\u043c\u0435\u0440 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f QUERY (A2:E6; &#8220;select avg (A) pivot B&#8221;) QUERY (A2:E6; F2; \u041b\u041e\u0416\u042c) \u0421\u0438\u043d\u0442\u0430\u043a\u0441\u0438\u0441 QUERY&#8230;<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[13],"tags":[],"class_list":["post-521312","post","type-post","status-publish","format-standard","hentry","category-kunsthaus-zurich-en","wpcat-13-id"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/posts\/521312","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/comments?post=521312"}],"version-history":[{"count":0,"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/posts\/521312\/revisions"}],"wp:attachment":[{"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/media?parent=521312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/categories?post=521312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/livelycity.com\/switzerland\/wp-json\/wp\/v2\/tags?post=521312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}