{"id":1829,"date":"2020-11-25T14:57:10","date_gmt":"2020-11-25T14:57:10","guid":{"rendered":"https:\/\/wdqs-tutorial.toolforge.org\/?p=1829"},"modified":"2020-11-30T08:24:24","modified_gmt":"2020-11-30T08:24:24","slug":"exercise-group-by-he","status":"publish","type":"post","link":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/modifying-results-he\/grouping-he\/exercise-group-by-he\/?lang=he","title":{"rendered":"\u05ea\u05e8\u05d2\u05d9\u05dc: GROUP BY"},"content":{"rendered":"\n<h4>| \u05ea\u05e8\u05d2\u05d9\u05dc: \u05db\u05ea\u05d1\u05d5 \u05e9\u05d0\u05d9\u05dc\u05ea\u05d4 \u05e9\u05de\u05e6\u05d9\u05d2\u05d4 \u05e1\u05e8\u05d8\u05d9\u05dd \u05e9\u05d4\u05d9\u05d5 \u05de\u05d5\u05e2\u05de\u05d3\u05d9\u05dd \u05dc\u05e4\u05e8\u05e1, \u05d5\u05d0\u05ea \u05de\u05e1\u05e4\u05e8 \u05d4\u05de\u05d5\u05e2\u05de\u05d3\u05d5\u05d9\u05d5\u05ea \u05e2\u05d1\u05d5\u05e8 \u05db\u05dc \u05e1\u05e8\u05d8.<\/h4>\n\n\n\n<p>\u05e8\u05de\u05d6: \u05d7\u05e4\u05e9\u05d5 \u05e1\u05e8\u05d8\u05d9\u05dd \u05e9\u05d9\u05e9 \u05dc\u05d4\u05dd \u05de\u05d0\u05e4\u05d9\u05d9\u05df P1411 (\u05de\u05d5\u05e2\u05de\u05d3\u05d5\u05ea \u05dc\u05e4\u05e8\u05e1)<\/p>\n\n\n\n<p>\u05d8\u05d9\u05e4: \u05d4\u05e9\u05d0\u05d9\u05dc\u05ea\u05d4 \u05e6\u05e8\u05d9\u05db\u05d4 \u05dc\u05d0\u05d7\u05d6\u05e8 \u05dc\u05d0 \u05e8\u05e7 \u05e4\u05e8\u05d9\u05d8\u05d9\u05dd \u05e9\u05d4\u05dd \u05de\u05d5\u05e4\u05e2 \u05e9\u05dc \u05e1\u05e8\u05d8 \u05e7\u05d5\u05dc\u05e0\u05d5\u05e2, \u05d0\u05dc\u05d0 \u05d2\u05dd \u05e4\u05e8\u05d9\u05d8\u05d9\u05dd \u05e9\u05d4\u05dd \u05de\u05d5\u05e4\u05e2 \u05e9\u05dc \u05ea\u05ea-\u05e7\u05d1\u05d5\u05e6\u05d4 \u05e9\u05dc \u05e1\u05e8\u05d8 \u05e7\u05d5\u05dc\u05e0\u05d5\u05e2. \u05d4\u05e9\u05ea\u05de\u05e9\u05d5 \u05d1\u05d4\u05d5\u05e8\u05d0\u05d4 <a href=\"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/simple-queries-he\/instances-and-classes-he\/distinct\/?lang=he\">DISTINCT<\/a> \u05db\u05d3\u05d9 \u05dc\u05d4\u05e1\u05d9\u05e8 \u05ea\u05d5\u05e6\u05d0\u05d5\u05ea \u05db\u05e4\u05d5\u05dc\u05d5\u05ea<\/p>\n\n\n\n<iframe class=\"\" src=\"https:\/\/query.wikidata.org\/\" style=\"width:100%;max-width:100%;height:450px\" frameborder=\"0\"><\/iframe>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details><summary class=\"wp-block-coblocks-accordion-item__title\">\u05e4\u05ea\u05e8\u05d5\u05df<\/summary><div class=\"wp-block-coblocks-accordion-item__content\">\n<p><\/p>\n\n\n\n<iframe class=\"\" src=\"https:\/\/query.wikidata.org\/#%23%20%D7%A1%D7%A8%D7%98%D7%99%D7%9D%20%D7%A9%D7%94%D7%99%D7%95%20%D7%9E%D7%95%D7%A2%D7%9E%D7%93%D7%99%D7%9D%20%D7%9C%D7%A4%D7%A8%D7%A1%2C%20%D7%95%D7%9E%D7%A1%D7%A4%D7%A8%20%D7%94%D7%9E%D7%95%D7%A2%D7%9E%D7%93%D7%95%D7%99%D7%95%D7%AA%0A%0ASELECT%20%3Fitem%20%3FitemLabel%20%28COUNT%28DISTINCT%20%3Faward%29%20AS%20%3Fcount%29%0AWHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279%2a%20wd%3AQ11424.%20%20%20%20%20%23%20%D7%94%D7%A4%D7%A8%D7%99%D7%98%20%D7%94%D7%95%D7%90%20%D7%9E%D7%95%D7%A4%D7%A2%20%D7%A9%D7%9C%20%D7%A1%D7%A8%D7%98%20%D7%A7%D7%95%D7%9C%D7%A0%D7%95%D7%A2%2C%20%D7%90%D7%95%20%D7%9E%D7%95%D7%A4%D7%A2%20%D7%A9%D7%9C%20%D7%AA%D7%AA-%D7%A7%D7%91%D7%95%D7%A6%D7%94%20%D7%A9%D7%9C%20%D7%A1%D7%A8%D7%98%20%D7%A7%D7%95%D7%9C%D7%A0%D7%95%D7%A2%0A%20%20%3Fitem%20wdt%3AP1411%20%3Faward.%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%20%3Faward%20%D7%94%D7%A4%D7%A8%D7%99%D7%98%20%D7%94%D7%99%D7%94%20%D7%9E%D7%95%D7%A2%D7%9E%D7%93%20%D7%9C%D7%A4%D7%A8%D7%A1%2C%20%D7%A9%D7%A0%D7%90%D7%A1%D7%A3%20%D7%A2%D7%9C%20%D7%99%D7%93%D7%99%20%D7%94%D7%9E%D7%A9%D7%AA%D7%A0%D7%94%20%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%22.%20%7D%0A%7D%0AGROUP%20BY%20%3Fitem%20%3FitemLabel%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%20%D7%94%D7%AA%D7%95%D7%A6%D7%90%D7%95%D7%AA%20%D7%9E%D7%95%D7%A6%D7%92%D7%95%D7%AA%20%D7%91%D7%A0%D7%A4%D7%A8%D7%93%20%D7%A2%D7%91%D7%95%D7%A8%20%D7%9B%D7%9C%20%D7%A1%D7%A8%D7%98\" style=\"width:100%;max-width:100%;height:450px\" frameborder=\"0\"><\/iframe>\n\n\n\n<p>\u05e9\u05d9\u05de\u05d5 \u05dc\u05d1 \u05e9\u05d4\u05d4\u05d5\u05e8\u05d0\u05d4 DISTINCT \u05de\u05ea\u05d9\u05d9\u05d7\u05e1\u05ea \u05d1\u05de\u05e7\u05e8\u05d4 \u05d6\u05d4 \u05dc\u05de\u05e9\u05ea\u05e0\u05d4 \u05e9\u05dc \u05d4\u05e4\u05e8\u05e1 \u05d5\u05dc\u05d0 \u05dc\u05e4\u05e8\u05d9\u05d8. \u05d0\u05dd \u05dc\u05e4\u05e8\u05d9\u05d8 \u05d9\u05e9 \u05d9\u05d5\u05ea\u05e8 \u05de\u05d4\u05e6\u05d4\u05e8\u05d4 \u05d0\u05d7\u05ea \u05e2\u05dd \u05d4\u05de\u05d0\u05e4\u05d9\u05d9\u05df P31 (\u05de\u05d5\u05e4\u05e2 \u05e9\u05dc) \u05d5\u05d9\u05e9 \u05dc\u05d5 \u05d9\u05d5\u05ea\u05e8 \u05de\u05e0\u05ea\u05d9\u05d1 \u05d0\u05d7\u05d3 \u05dc\u05de\u05d7\u05dc\u05e7\u05d4 \u05e1\u05e8\u05d8 \u05e7\u05d5\u05dc\u05e0\u05d5\u05e2 (\u05dc\u05de\u05e9\u05dc, \u05d4\u05e4\u05e8\u05d9\u05d8 \u05de\u05d5\u05d2\u05d3\u05e8 \u05d2\u05dd \u05db\u05de\u05d5\u05e4\u05e2 \u05e9\u05dc \u05e1\u05e8\u05d8 \u05e7\u05d5\u05dc\u05e0\u05d5\u05e2 \u05d5\u05d2\u05dd \u05db\u05de\u05d5\u05e4\u05e2 \u05e9\u05dc \u05e1\u05e8\u05d8 \u05ea\u05dc\u05ea-\u05de\u05de\u05d3 \u2013 \u05e9\u05d4\u05d5\u05d0 \u05ea\u05ea-\u05e7\u05d1\u05d5\u05e6\u05d4 \u05e9\u05dc \u05e1\u05e8\u05d8 \u05e7\u05d5\u05dc\u05e0\u05d5\u05e2), DISTINCT \u05d9\u05d5\u05d5\u05d3\u05d0 \u05e9\u05d4\u05de\u05d5\u05e2\u05de\u05d3\u05d5\u05d9\u05d5\u05ea \u05dc\u05e4\u05e8\u05e1 \u05d9\u05d9\u05e1\u05e4\u05e8\u05d5 \u05e8\u05e7 \u05e4\u05e2\u05dd \u05d0\u05d7\u05ea.<\/p>\n\n\n\n<p>\u05db\u05d3\u05d9 \u05dc\u05e8\u05d0\u05d5\u05ea \u05dc\u05d0\u05d9\u05d6\u05d4 \u05e1\u05e8\u05d8 \u05d4\u05d9\u05d5 \u05d4\u05db\u05d9 \u05d4\u05e8\u05d1\u05d4 \u05de\u05d5\u05e2\u05de\u05d3\u05d5\u05d9\u05d5\u05ea, \u05d0\u05e4\u05e9\u05e8 \u05dc\u05d2\u05dc\u05d5\u05dc \u05dc\u05ea\u05d5\u05e6\u05d0\u05d5\u05ea \u05dc\u05d0\u05d7\u05e8 \u05d4\u05e8\u05e6\u05ea \u05d4\u05e9\u05d0\u05d9\u05dc\u05ea\u05d4, \u05d5\u05dc\u05dc\u05d7\u05d5\u05e5 \u05e2\u05dc \u05d4\u05e2\u05de\u05d5\u05d3\u05d4 &#8220;count&#8221; \u05d1\u05e8\u05d0\u05e9 \u05d4\u05d8\u05d1\u05dc\u05d4. \u05e4\u05e2\u05d5\u05dc\u05d4 \u05d6\u05d5 \u05ea\u05d3\u05e8\u05d2 \u05d0\u05ea \u05d4\u05ea\u05d5\u05e6\u05d0\u05d5\u05ea \u05dc\u05e4\u05d9 \u05e2\u05de\u05d5\u05d3\u05d4 \u05d6\u05d5. \u05d1\u05e4\u05e8\u05e7 \u05d4\u05d1\u05d0 \u05ea\u05dc\u05de\u05d3\u05d5 \u05d0\u05d9\u05da \u05dc\u05d4\u05d5\u05e8\u05d5\u05ea \u05dc\u05d3\u05e8\u05d2 \u05d0\u05ea \u05d4\u05ea\u05d5\u05e6\u05d0\u05d5\u05ea \u05d1\u05d2\u05d5\u05e3 \u05d4\u05e9\u05d0\u05d9\u05dc\u05ea\u05d4.<\/p>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>| \u05ea\u05e8\u05d2\u05d9\u05dc: \u05db\u05ea\u05d1\u05d5 \u05e9\u05d0\u05d9\u05dc\u05ea\u05d4 \u05e9\u05de\u05e6\u05d9\u05d2\u05d4 \u05e1\u05e8\u05d8\u05d9\u05dd \u05e9\u05d4\u05d9\u05d5 \u05de\u05d5\u05e2\u05de\u05d3\u05d9\u05dd \u05dc\u05e4\u05e8\u05e1, \u05d5\u05d0\u05ea \u05de\u05e1\u05e4\u05e8 \u05d4\u05de\u05d5\u05e2\u05de\u05d3\u05d5\u05d9\u05d5\u05ea \u05e2\u05d1\u05d5\u05e8 \u05db\u05dc \u05e1\u05e8\u05d8. \u05e8\u05de\u05d6: \u05d7\u05e4\u05e9\u05d5 \u05e1\u05e8\u05d8\u05d9\u05dd \u05e9\u05d9\u05e9 \u05dc\u05d4\u05dd \u05de\u05d0\u05e4\u05d9\u05d9\u05df P1411 (\u05de\u05d5\u05e2\u05de\u05d3\u05d5\u05ea \u05dc\u05e4\u05e8\u05e1) \u05d8\u05d9\u05e4: \u05d4\u05e9\u05d0\u05d9\u05dc\u05ea\u05d4 \u05e6\u05e8\u05d9\u05db\u05d4 \u05dc\u05d0\u05d7\u05d6\u05e8 \u05dc\u05d0 \u05e8\u05e7 \u05e4\u05e8\u05d9\u05d8\u05d9\u05dd \u05e9\u05d4\u05dd \u05de\u05d5\u05e4\u05e2 \u05e9\u05dc \u05e1\u05e8\u05d8 \u05e7\u05d5\u05dc\u05e0\u05d5\u05e2, \u05d0\u05dc\u05d0 \u05d2\u05dd \u05e4\u05e8\u05d9\u05d8\u05d9\u05dd \u05e9\u05d4\u05dd \u05de\u05d5\u05e4\u05e2 \u05e9\u05dc \u05ea\u05ea-\u05e7\u05d1\u05d5\u05e6\u05d4 \u05e9\u05dc \u05e1\u05e8\u05d8 \u05e7\u05d5\u05dc\u05e0\u05d5\u05e2. \u05d4\u05e9\u05ea\u05de\u05e9\u05d5 \u05d1\u05d4\u05d5\u05e8\u05d0\u05d4 DISTINCT \u05db\u05d3\u05d9 \u05dc\u05d4\u05e1\u05d9\u05e8 \u05ea\u05d5\u05e6\u05d0\u05d5\u05ea \u05db\u05e4\u05d5\u05dc\u05d5\u05ea<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":""},"categories":[27],"tags":[],"_links":{"self":[{"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/posts\/1829"}],"collection":[{"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/comments?post=1829"}],"version-history":[{"count":10,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/posts\/1829\/revisions"}],"predecessor-version":[{"id":1991,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/posts\/1829\/revisions\/1991"}],"wp:attachment":[{"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/media?parent=1829"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/categories?post=1829"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/tags?post=1829"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}