{"id":1103,"date":"2022-10-06T09:02:17","date_gmt":"2022-10-06T13:02:17","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1103"},"modified":"2022-10-06T09:02:17","modified_gmt":"2022-10-06T13:02:17","slug":"introduction-to-structured-query-language-for-data-analytics-sf22sql1001-day-3","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1103","title":{"rendered":"Introduction to Structured Query Language for Data Analytics (SF22SQL1001) \u2014 Day 3"},"content":{"rendered":"<p>We have covered basic <tt>SELECT<\/tt> statements joining (<tt>INNER|LEFT|RIGHT JOIN<\/tt>) multiple tables, filtering data (<tt>WHERE<\/tt>) and organizing the output (<tt>ORDER BY<\/tt>) as well grouping values (<tt>GROUP BY<\/tt>) when using aggregate functions. Now we are having fun with SQL.<\/p>\n<p>Download the <a href=\"https:\/\/folvera.commons.gc.cuny.edu\/wp-content\/blogs.dir\/2501\/files\/2022\/10\/SF22SQL1001_20221008.pdf\">class notes<\/a> for day 3.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We have covered basic SELECT statements joining (INNER|LEFT|RIGHT JOIN) multiple tables, filtering data (WHERE) and organizing the output (ORDER BY) as well grouping values (GROUP BY) when using aggregate functions. Now we are having fun with SQL. Download the class notes for day 3.<\/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":[31,3,1,2],"tags":[],"class_list":["post-1103","post","type-post","status-publish","format-standard","hentry","category-sf22sql1001","category-computer-programming","category-cuny","category-sql"],"_links":{"self":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1103","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=1103"}],"version-history":[{"count":1,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1103\/revisions"}],"predecessor-version":[{"id":1105,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1103\/revisions\/1105"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}