{"id":1219,"date":"2023-04-13T11:51:09","date_gmt":"2023-04-13T15:51:09","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1219"},"modified":"2023-04-13T11:51:09","modified_gmt":"2023-04-13T15:51:09","slug":"introduction-to-structured-query-language-for-data-analytics-ws23sql1001-day-4","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1219","title":{"rendered":"Introduction to Structured Query Language for Data Analytics (WS23SQL1001) \u2014 Day 4"},"content":{"rendered":"<p>We have started working with functions \u2014 currently playing with aggregate functions and the need to use <tt>GROUP BY<\/tt> when calling fields that are not subject to any aggregate function.<\/p>\n<p>Download the <a href=\"https:\/\/folvera.commons.gc.cuny.edu\/wp-content\/blogs.dir\/2501\/files\/2023\/04\/WS23SQL1001_20230412.pdf\">class notes<\/a> for day 4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We have started working with functions \u2014 currently playing with aggregate functions and the need to use GROUP BY when calling fields that are not subject to any aggregate function. Download the class notes for day 4.<\/p>\n","protected":false},"author":7213,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"send_to_group_blog":0,"footnotes":""},"categories":[33,3,1,2],"tags":[],"class_list":["post-1219","post","type-post","status-publish","format-standard","hentry","category-ws23sql1001","category-computer-programming","category-cuny","category-sql"],"_links":{"self":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1219","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/users\/7213"}],"replies":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1219"}],"version-history":[{"count":1,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1219\/revisions"}],"predecessor-version":[{"id":1221,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1219\/revisions\/1221"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1219"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}