{"id":12388,"date":"2021-01-12T11:47:59","date_gmt":"2021-01-12T19:47:59","guid":{"rendered":"https:\/\/careerkarma.com\/blog\/?p=12388"},"modified":"2023-12-01T04:08:00","modified_gmt":"2023-12-01T12:08:00","slug":"sql-aggregate-functions","status":"publish","type":"post","link":"https:\/\/careerkarma.com\/blog\/sql-aggregate-functions\/","title":{"rendered":"SQL Aggregate Functions: A Complete Guide"},"content":{"rendered":"\n<p><em>SQL aggregate functions retrieve information about the data in a database. You can use COUNT to find out how many records are in a database, for instance. Accepted aggregate functions are: COUNT, MIN, MAX, AVG, and SUM.<\/em><\/p>\n\n\n\n<p>There are occasions where you may want to get information about the data, but not the data itself. Perhaps you want to know how many employees are based in each office, or who has worked for your business the longest. This is where <em>SQL aggregate functions<\/em> come in.<\/p>\n\n\n\n<p>In this guide, we\u2019ll discuss the basics of <em>SQL aggregate functions<\/em>, how they work, and how you can use them in your queries.<\/p>\n\n\n\n<p><em>Note: We are using PostgreSQL for the purposes of this article.<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Aggregate Functions<\/h2>\n\n\n\n<p>SQL aggregate functions collate information about what is in a database. For instance, you can use SUM to find the total of all the values in a column. Aggregate functions save you time when you need to find out information that involves aggregating records.,<\/p>\n\n\n\n<p>Here is a list of the aggregate functions in SQL you can use:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>COUNT<\/li><li>SUM<\/li><li>AVG<\/li><li>MIN<\/li><li>MAX<\/li><\/ul>\n\n\n\n<p>Let&#8217;s walk through each of these individually. We&#8217;re going to be referring to a database of employees throughout this tutorial.<\/p>\n\n\n\n<p>Aggregate functions are used at the beginning of the <a href=\"https:\/\/careerkarma.com\/blog\/sql-select\/\">SQL SELECT statement<\/a>.<\/p>\n\n\n\n<p>If you query both a column and an aggregate function in the same SELECT statement, you must use an <a href=\"https:\/\/careerkarma.com\/blog\/sql-group-by\/\">SQL GROUP BY clause<\/a>. This clause tells SQL how to represent the data in your query.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL COUNT<\/h2>\n\n\n\n<p>The SQL <em>COUNT<\/em> function returns the total number of rows returned by a query. Using a WHERE statement, the COUNT function returns the number of rows that meet your condition.<\/p>\n\n\n\n<p>For example, say you wanted to know how many employees work in the Stamford branch of your business. You could find this information out using the following query:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT COUNT(name) FROM employees WHERE branch = &quot;Stamford&quot;;<\/pre><\/div>\n\n\n\n<p>Our query returns the number of employees working at the Stamford branch:<\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td>count<\/td><\/tr><tr><td>1<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p>(1 row)<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL MIN and MAX<\/h2>\n\n\n\n<p>The SQL <em>MIN<\/em> function returns the smallest value within a column. An SQL <em>MAX<\/em> statement returns the largest value in a column. Both of these statements are SQL aggregate functions.<\/p>\n\n\n\n<p>For example, say you want to get the lowest number of <em>employee of the month<\/em> awards held by a single person. We could retrieve this data using this query:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT MIN(employee_month_awards) FROM employees;<\/pre><\/div>\n\n\n\n<p>Our query returns:<\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td>min<\/td><\/tr><tr><td>1<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p>(1 row)<\/p>\n\n\n\n<p>Say we wanted to get the highest number of <em>employee of the month<\/em> awards held by a single person. To do so, we would use the <em>MAX<\/em> function instead:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT MAX(employee_month_awards) FROM employees;<\/pre><\/div>\n\n\n\n<p>The output for our query is as follows:<\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td>max<\/td><\/tr><tr><td>6<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p>(1 row)<\/p>\n\n\n\n<p>Of note, you can use the <em>MIN<\/em> and <em>MAX<\/em> functions on both numeric and alphabetic information in your database.<\/p>\n\n\n\n<p>If you wanted to get the name that appeared first in the alphabet from your database, you could use <em>MIN<\/em>(name). Likewise, <em>MAX<\/em>(name) could be used to get the name that comes last in the alphabet.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL AVG<\/h2>\n\n\n\n<p>The SQL AVG function returns the average value of a particular column. <\/p>\n\n\n\n<p>Let\u2019s say we want to get the average number of <em>employee of the month<\/em> awards held by each employee. We would use the following query to accomplish this goal:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT AVG(employee_month_awards) FROM employees;<\/pre><\/div>\n\n\n\n<p>Our query calculates the average of the <em>employee of the month<\/em> data and returns the following result set:<\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td>avg<\/td><\/tr><tr><td>4<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p>(1 row)<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL SUM<\/h2>\n\n\n\n<p>The SQL <em>SUM<\/em> function finds the total sum of a particular column.<\/p>\n\n\n\n<p>Suppose you want to find out how many <em>employee of the month<\/em> awards have ever been issued. This information is readily accessible if you use an SQL SUM statement:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT SUM(employee_month_awards) FROM employees;<\/pre><\/div>\n\n\n\n<p>Our query returns the following:<\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td>sum<\/td><\/tr><tr><td>20<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p>(1 row)<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>SQL aggregate functions return information about the data in a database. AVG, for instance, returns the average of the values in a database column. There are five aggregate functions, which are: MIN, MAX, COUNT, SUM, and AVG.<\/p>\n\n\n\n<p>Are you up for a challenge?<\/p>\n\n\n\n<p>Write an aggregate function that finds out the number of employees with the name &#8220;Linda&#8221;. Compare your query with our queries above to see if it makes sense.<\/p>\n\n\n\n<p>We have written a comprehensive guide on how to learn SQL. If you&#8217;re looking for new learning resources, check out the guide on our <a href=\"https:\/\/careerkarma.com\/blog\/learn-sql\/\">How to Learn SQL page<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"SQL aggregate functions retrieve information about the data in a database. You can use COUNT to find out how many records are in a database, for instance. Accepted aggregate functions are: COUNT, MIN, MAX, AVG, and SUM. There are occasions where you may want to get information about the data, but not the data itself.&hellip;","protected":false},"author":240,"featured_media":12389,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[17284],"tags":[],"class_list":{"0":"post-12388","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-sql"},"acf":{"post_sub_title":"","sprint_id":"","query_class":"SQL","school_sft":"","parent_sft":"","school_privacy_policy":"","has_review":null,"is_sponser_post":"","is_guest_post":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.4 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Aggregate Functions: A Complete Guide: A Complete Guide | Career Karma<\/title>\n<meta name=\"description\" content=\"SQL aggregate functions help programmers get more information about databases. Learn more about SQL aggregate functions in this article.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/careerkarma.com\/blog\/sql-aggregate-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Aggregate Functions: A Complete Guide\" \/>\n<meta property=\"og:description\" content=\"SQL aggregate functions help programmers get more information about databases. Learn more about SQL aggregate functions in this article.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/careerkarma.com\/blog\/sql-aggregate-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"Career Karma\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/facebook.com\/careerkarmaapp\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-12T19:47:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-01T12:08:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-AGGREGATE.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"667\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"James Gallagher\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@career_karma\" \/>\n<meta name=\"twitter:site\" content=\"@career_karma\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"James Gallagher\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-aggregate-functions\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-aggregate-functions\\\/\"},\"author\":{\"name\":\"James Gallagher\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/#\\\/schema\\\/person\\\/e79364792443fbff794a144c67ec8e94\"},\"headline\":\"SQL Aggregate Functions: A Complete Guide\",\"datePublished\":\"2021-01-12T19:47:59+00:00\",\"dateModified\":\"2023-12-01T12:08:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-aggregate-functions\\\/\"},\"wordCount\":713,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-aggregate-functions\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/SQL-AGGREGATE.jpg\",\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-aggregate-functions\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-aggregate-functions\\\/\",\"url\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-aggregate-functions\\\/\",\"name\":\"SQL Aggregate Functions: A Complete Guide: A Complete Guide | Career Karma\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-aggregate-functions\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-aggregate-functions\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/SQL-AGGREGATE.jpg\",\"datePublished\":\"2021-01-12T19:47:59+00:00\",\"dateModified\":\"2023-12-01T12:08:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/#\\\/schema\\\/person\\\/e79364792443fbff794a144c67ec8e94\"},\"description\":\"SQL aggregate functions help programmers get more information about databases. Learn more about SQL aggregate functions in this article.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-aggregate-functions\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-aggregate-functions\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-aggregate-functions\\\/#primaryimage\",\"url\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/SQL-AGGREGATE.jpg\",\"contentUrl\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/SQL-AGGREGATE.jpg\",\"width\":1000,\"height\":667},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql-aggregate-functions\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog\",\"item\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL\",\"item\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/sql\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SQL Aggregate Functions: A Complete Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/\",\"name\":\"Career Karma\",\"description\":\"Latest Coding Bootcamp News &amp; Career Hacks from Industry Insiders\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/#\\\/schema\\\/person\\\/e79364792443fbff794a144c67ec8e94\",\"name\":\"James Gallagher\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/james-gallagher-150x150.jpg\",\"url\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/james-gallagher-150x150.jpg\",\"contentUrl\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/james-gallagher-150x150.jpg\",\"caption\":\"James Gallagher\"},\"description\":\"James Gallagher is a self-taught programmer and the technical content manager at Career Karma. He has experience in range of programming languages and extensive expertise in Python, HTML, CSS, and JavaScript. James has written hundreds of programming tutorials, and he frequently contributes to publications like Codecademy, Treehouse, Repl.it, Afrotech, and others.\",\"url\":\"https:\\\/\\\/careerkarma.com\\\/blog\\\/author\\\/jamesgallagher\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Aggregate Functions: A Complete Guide: A Complete Guide | Career Karma","description":"SQL aggregate functions help programmers get more information about databases. Learn more about SQL aggregate functions in this article.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/careerkarma.com\/blog\/sql-aggregate-functions\/","og_locale":"en_US","og_type":"article","og_title":"SQL Aggregate Functions: A Complete Guide","og_description":"SQL aggregate functions help programmers get more information about databases. Learn more about SQL aggregate functions in this article.","og_url":"https:\/\/careerkarma.com\/blog\/sql-aggregate-functions\/","og_site_name":"Career Karma","article_publisher":"http:\/\/facebook.com\/careerkarmaapp","article_published_time":"2021-01-12T19:47:59+00:00","article_modified_time":"2023-12-01T12:08:00+00:00","og_image":[{"width":1000,"height":667,"url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-AGGREGATE.jpg","type":"image\/jpeg"}],"author":"James Gallagher","twitter_card":"summary_large_image","twitter_creator":"@career_karma","twitter_site":"@career_karma","twitter_misc":{"Written by":"James Gallagher","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/careerkarma.com\/blog\/sql-aggregate-functions\/#article","isPartOf":{"@id":"https:\/\/careerkarma.com\/blog\/sql-aggregate-functions\/"},"author":{"name":"James Gallagher","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94"},"headline":"SQL Aggregate Functions: A Complete Guide","datePublished":"2021-01-12T19:47:59+00:00","dateModified":"2023-12-01T12:08:00+00:00","mainEntityOfPage":{"@id":"https:\/\/careerkarma.com\/blog\/sql-aggregate-functions\/"},"wordCount":713,"commentCount":0,"image":{"@id":"https:\/\/careerkarma.com\/blog\/sql-aggregate-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-AGGREGATE.jpg","articleSection":["SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/careerkarma.com\/blog\/sql-aggregate-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/careerkarma.com\/blog\/sql-aggregate-functions\/","url":"https:\/\/careerkarma.com\/blog\/sql-aggregate-functions\/","name":"SQL Aggregate Functions: A Complete Guide: A Complete Guide | Career Karma","isPartOf":{"@id":"https:\/\/careerkarma.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/careerkarma.com\/blog\/sql-aggregate-functions\/#primaryimage"},"image":{"@id":"https:\/\/careerkarma.com\/blog\/sql-aggregate-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-AGGREGATE.jpg","datePublished":"2021-01-12T19:47:59+00:00","dateModified":"2023-12-01T12:08:00+00:00","author":{"@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94"},"description":"SQL aggregate functions help programmers get more information about databases. Learn more about SQL aggregate functions in this article.","breadcrumb":{"@id":"https:\/\/careerkarma.com\/blog\/sql-aggregate-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/careerkarma.com\/blog\/sql-aggregate-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/careerkarma.com\/blog\/sql-aggregate-functions\/#primaryimage","url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-AGGREGATE.jpg","contentUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-AGGREGATE.jpg","width":1000,"height":667},{"@type":"BreadcrumbList","@id":"https:\/\/careerkarma.com\/blog\/sql-aggregate-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/careerkarma.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL","item":"https:\/\/careerkarma.com\/blog\/sql\/"},{"@type":"ListItem","position":3,"name":"SQL Aggregate Functions: A Complete Guide"}]},{"@type":"WebSite","@id":"https:\/\/careerkarma.com\/blog\/#website","url":"https:\/\/careerkarma.com\/blog\/","name":"Career Karma","description":"Latest Coding Bootcamp News &amp; Career Hacks from Industry Insiders","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/careerkarma.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94","name":"James Gallagher","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/01\/james-gallagher-150x150.jpg","url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/01\/james-gallagher-150x150.jpg","contentUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/01\/james-gallagher-150x150.jpg","caption":"James Gallagher"},"description":"James Gallagher is a self-taught programmer and the technical content manager at Career Karma. He has experience in range of programming languages and extensive expertise in Python, HTML, CSS, and JavaScript. James has written hundreds of programming tutorials, and he frequently contributes to publications like Codecademy, Treehouse, Repl.it, Afrotech, and others.","url":"https:\/\/careerkarma.com\/blog\/author\/jamesgallagher\/"}]}},"_links":{"self":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts\/12388","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/users\/240"}],"replies":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/comments?post=12388"}],"version-history":[{"count":0,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts\/12388\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/media\/12389"}],"wp:attachment":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/media?parent=12388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/categories?post=12388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/tags?post=12388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}