{"id":611,"date":"2018-02-15T12:07:50","date_gmt":"2018-02-15T17:07:50","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=611"},"modified":"2021-09-16T14:57:58","modified_gmt":"2021-09-16T18:57:58","slug":"database-administration-fundamentals-ws18sql1001-day-3","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=611","title":{"rendered":"Database Administration Fundamentals (WS18SQL1001) \u2013 Day 3"},"content":{"rendered":"

We have started having fun with built-in\u00a0functions<\/a>\u00a0(set of instructions) for numeric values.<\/p>\n

    \n
  1. SUM()<\/tt><\/a> — total value of row<\/li>\n
  2. AVG()<\/tt><\/a> — average value of a row<\/li>\n
  3. COUNT()<\/tt><\/a> — how many records<\/li>\n
  4. ROUND()<\/tt><\/a> — rounding a number to a specific decimal point (decimal, float, double, money…)<\/li>\n
  5. CEILING()<\/tt><\/a> — rounding up to the closest whole number value (integer)<\/li>\n
  6. FLOOR()<\/tt><\/a> — rounding down to the closest whole number value (integer)<\/li>\n
  7. MAX()<\/tt><\/a> — highest value<\/li>\n
  8. MIN()<\/tt><\/a> — lowest value<\/li>\n
  9. RAND()<\/tt><\/a> — random value<\/li>\n
  10. FORMAT()<\/tt> — “dress”<\/em> value for date or currency ($5.00, 2\/14\/2018, 14-FEB-18); outputs VARCHAR(n)<\/tt><\/li>\n<\/ol>\n

    Download the\u00a0notes<\/a>\u00a0for day 3.<\/p>\n","protected":false},"excerpt":{"rendered":"

    We have started having fun with built-in\u00a0functions\u00a0(set of instructions) for numeric values. SUM() — total value of row AVG() — average value of a row COUNT() — how many records ROUND() — rounding a number to a specific decimal point (decimal, float, double, money…) CEILING() — rounding up to the closest whole number value (integer) […]<\/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":[21,3,1,17,2],"tags":[],"class_list":["post-611","post","type-post","status-publish","format-standard","hentry","category-ws18sql1001","category-computer-programming","category-cuny","category-open-source","category-sql"],"_links":{"self":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/611","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=611"}],"version-history":[{"count":4,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/611\/revisions"}],"predecessor-version":[{"id":616,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/611\/revisions\/616"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=611"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=611"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=611"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}