{"id":417,"date":"2021-11-11T11:09:24","date_gmt":"2021-11-11T11:09:24","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/?page_id=417"},"modified":"2021-11-11T11:09:24","modified_gmt":"2021-11-11T11:09:24","slug":"higher","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/higher\/","title":{"rendered":"Higher"},"content":{"rendered":"<p>You need to be able to:<\/p>\n<ul>\n<li>Describe, exemplify and use SQL operations for pre-populated relational databases, with three or more linked tables:\n<ul>\n<li>UPDATE, SELECT, DELETE, INSERT statements making use of:\n<ul>\n<li>wildcards<\/li>\n<li>aggregate functions (MIN, MAX, AVG, SUM, COUNT)<\/li>\n<li>computed values, alias<\/li>\n<li>GROUP BY<\/li>\n<li>ORDER BY<\/li>\n<li>WHERE<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>You need to be able to: Describe, exemplify and use SQL operations for pre-populated relational databases, with three or more linked tables: UPDATE, SELECT, DELETE, INSERT statements making use of: wildcards aggregate functions (MIN, MAX, AVG, SUM, COUNT) computed values, alias GROUP BY ORDER BY WHERE<\/p>\n","protected":false},"author":7,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-417","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/417","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/comments?post=417"}],"version-history":[{"count":1,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/417\/revisions"}],"predecessor-version":[{"id":419,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/417\/revisions\/419"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/media?parent=417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}