{"id":153,"date":"2011-10-02T12:38:17","date_gmt":"2011-10-02T12:38:17","guid":{"rendered":"http:\/\/sql.programisius.lt\/?page_id=153"},"modified":"2011-10-02T12:38:17","modified_gmt":"2011-10-02T12:38:17","slug":"3-duomenu-grupavimas","status":"publish","type":"page","link":"http:\/\/sql.programisius.lt\/?page_id=153","title":{"rendered":"3. Duomen\u0173 grupavimas"},"content":{"rendered":"<p>1.<\/p>\n<blockquote><p>SELECT rajonas, COUNT(rajonas) FROM klientai GROUP BY rajonas;<\/p><\/blockquote>\n<p>2.<\/p>\n<blockquote><p>SELECT preke, MIN(kaina), MAX(kaina) FROM uzsakymu_sarasas GROUP BY preke;<\/p><\/blockquote>\n<p>3.<\/p>\n<blockquote><p>SELECT klientoid, COUNT(*) FROM uzsakymu_sarasas GROUP BY klientoid;<\/p><\/blockquote>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. SELECT rajonas, COUNT(rajonas) FROM klientai GROUP BY rajonas; 2. SELECT preke, MIN(kaina), MAX(kaina) FROM uzsakymu_sarasas GROUP BY preke; 3. SELECT klientoid, COUNT(*) FROM uzsakymu_sarasas GROUP BY klientoid; &nbsp;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":117,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-153","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/153","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=153"}],"version-history":[{"count":1,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/153\/revisions"}],"predecessor-version":[{"id":154,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/153\/revisions\/154"}],"up":[{"embeddable":true,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/117"}],"wp:attachment":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}