{"id":20864,"date":"2020-08-06T00:24:38","date_gmt":"2020-08-06T07:24:38","guid":{"rendered":"https:\/\/careerkarma.com\/blog\/?p=20864"},"modified":"2020-12-29T06:39:55","modified_gmt":"2020-12-29T14:39:55","slug":"sql-having","status":"publish","type":"post","link":"https:\/\/careerkarma.com\/blog\/sql-having\/","title":{"rendered":"SQL Having"},"content":{"rendered":"\n<p>SQL has different types of operations used to make queries to a database. SQL\u2019s HAVING statement works like a subquery on top of an initial query. It works well when you have an overwhelming amount of entries that have one value in common and you want to filter it further. In this article, we take a look to see how it works.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Preparation<\/h2>\n\n\n\n<p>In this<a href=\"http:\/\/sqlfiddle.com\/#!9\/a9c164\/6\/0\" target=\"_blank\" rel=\"noopener\" rel=\"nofollow\"> SQL Fiddle <\/a>&nbsp;using MySQL, I\u2019ve created a sample schema used for these examples.  <\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>create table Cars (\n\tid INT PRIMARY KEY,\n\tyear VARCHAR(50),\n\tcar_make VARCHAR(50),\n\tcar_model VARCHAR(50)\n);<\/pre><\/div>\n\n\n\n<p>This creates a table called \u201cCars\u201d and has a schema that looks at each car\u2019s make model and year. The next block inserts values into those columns:<br><\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>insert into Cars (id, year, car_make, car_model) values (1, 2011, 'Mazda', 'Miata MX-5');\ninsert into Cars (id, year, car_make, car_model) values (2, 1969, 'Ford', 'Mustang');\ninsert into Cars (id, year, car_make, car_model) values (3, 2007, 'Toyota', '4Runner');\ninsert into Cars (id, year, car_make, car_model) values (4, 2013, 'Porsche', '911');\ninsert into Cars (id, year, car_make, car_model) values (5, 1991, 'Buick', 'Coachbuilder');\ninsert into Cars (id, year, car_make, car_model) values (6, 2007, 'Kia', 'Sportage');\ninsert into Cars (id, year, car_make, car_model) values (7, 1997, 'Oldsmobile', 'Cutlass Supreme');\ninsert into Cars (id, year, car_make, car_model) values (8, 2003, 'BMW', '7 Series');\ninsert into Cars (id, year, car_make, car_model) values (9, 1996, 'Ford', 'F150');\ninsert into Cars (id, year, car_make, car_model) values (10, 1992, 'Suzuki', 'SJ');\ninsert into Cars (id, year, car_make, car_model) values (11, 2001, 'Jeep', 'Grand Cherokee');\ninsert into Cars (id, year, car_make, car_model) values (12, 2000, 'Ford', 'F250');\ninsert into Cars (id, year, car_make, car_model) values (13, 2003, 'Honda', 'Insight');\ninsert into Cars (id, year, car_make, car_model) values (14, 2006, 'Chevrolet', 'HHR Panel');\ninsert into Cars (id, year, car_make, car_model) values (15, 1987, 'Mercedes-Benz', 'S-Class');\ninsert into Cars (id, year, car_make, car_model) values (16, 2004, 'Chevrolet', 'SSR');\ninsert into Cars (id, year, car_make, car_model) values (17, 1990, 'Maserati', '228');\ninsert into Cars (id, year, car_make, car_model) values (18, 2005, 'Saturn', 'Ion');\ninsert into Cars (id, year, car_make, car_model) values (19, 1987, 'Audi', '5000CS');\ninsert into Cars (id, year, car_make, car_model) values (20, 1999, 'Chevrolet', 'S10');\ninsert into Cars (id, year, car_make, car_model) values (21, 2007, 'Jeep', 'Liberty');\ninsert into Cars (id, year, car_make, car_model) values (22, 2002, 'Lamborghini', 'Murci\u00e9lago');\ninsert into Cars (id, year, car_make, car_model) values (23, 2000, 'Hyundai', 'Tiburon');\ninsert into Cars (id, year, car_make, car_model) values (24, 2011, 'Jeep', 'Patriot');\ninsert into Cars (id, year, car_make, car_model) values (25, 1985, 'Pontiac', 'Sunbird');<\/pre><\/div>\n\n\n\n<p>If you would like to mock your own data for this exercise, I recommend using mockaroo.com to do that. You can structure your database schema pretty simply using this method.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How to Use HAVING<\/h2>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT COUNT(id), car_make\nFROM Cars\nGROUP BY car_make\nHAVING COUNT(id) &gt; 0;<\/pre><\/div>\n\n\n\n<p>Use HAVING when you need to use an aggregate function and the WHERE clause can\u2019t be used. An aggregate functions are those functions that perform some sort of operation and return a single value. Think COUNT, AVG, or SUM. The code above returns:<\/p>\n\n\n\n<p><\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td>COUNT(id)<\/td><td>car_make<\/td><\/tr><tr><td>1<\/td><td>Audi<\/td><\/tr><tr><td>1<\/td><td>BMW<\/td><\/tr><tr><td>1<\/td><td>Buick<\/td><\/tr><tr><td>3<\/td><td>Chevrolet<\/td><\/tr><tr><td>3<\/td><td>Ford<\/td><\/tr><tr><td>1<\/td><td>Honda<\/td><\/tr><tr><td>1<\/td><td>Hyundai<\/td><\/tr><tr><td>3<\/td><td>Jeep<\/td><\/tr><tr><td>1<\/td><td>Kia<\/td><\/tr><tr><td>1&nbsp;<\/td><td>Lamborghini<\/td><\/tr><tr><td>1<\/td><td>Maserati<\/td><\/tr><tr><td>1&nbsp;<\/td><td>Mazda<\/td><\/tr><tr><td>1<\/td><td>Mercedes-Benz<\/td><\/tr><tr><td>1<\/td><td>Oldsmobile<\/td><\/tr><tr><td>1<\/td><td>Pontiac<\/td><\/tr><tr><td>1<\/td><td>Porsche<\/td><\/tr><tr><td>1<\/td><td>Saturn<\/td><\/tr><tr><td>1<\/td><td>Suzuki<\/td><\/tr><tr><td>1<\/td><td>Toyota<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p><\/p>\n\n\n\n<p>We use a select statement to grab the sql COUNT of car_makes that exist and a group by clause to separate them by car_make.<br><\/p>\n\n\n\n<p>That\u2019s all there is to it! As a reminder, the HAVING clause in an SQL query is a subfilter that uses an aggregate function to perform some additional query work on a database.&nbsp;<br><\/p>\n\n\n\n<p>Experiment with other aggregate functions to increase knowledge of this unique clause!<\/p>\n","protected":false},"excerpt":{"rendered":"SQL has different types of operations used to make queries to a database. SQL\u2019s HAVING statement works like a subquery on top of an initial query. It works well when you have an overwhelming amount of entries that have one value in common and you want to filter it further. In this article, we take&hellip;","protected":false},"author":77,"featured_media":15988,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[17284],"tags":[],"class_list":{"0":"post-20864","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.0 (Yoast SEO v27.0) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Having: is a subquery on top of an initial query<\/title>\n<meta name=\"description\" content=\"The SQL HAVING clause allows us to perform aggregate functions in our SQL queries. Learn more about it with this article from Career Karma.\" \/>\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-having\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Having\" \/>\n<meta property=\"og:description\" content=\"The SQL HAVING clause allows us to perform aggregate functions in our SQL queries. Learn more about it with this article from Career Karma.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/careerkarma.com\/blog\/sql-having\/\" \/>\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=\"2020-08-06T07:24:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-29T14:39:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/05\/caspar-camille-rubin-fPkvU7RDmCo-unsplash.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1020\" \/>\n\t<meta property=\"og:image:height\" content=\"680\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Christina Kopecky\" \/>\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=\"Christina Kopecky\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-having\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-having\/\"},\"author\":{\"name\":\"Christina Kopecky\",\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/ae0cdc4a5d198690d78482646894074e\"},\"headline\":\"SQL Having\",\"datePublished\":\"2020-08-06T07:24:38+00:00\",\"dateModified\":\"2020-12-29T14:39:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-having\/\"},\"wordCount\":288,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-having\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/05\/caspar-camille-rubin-fPkvU7RDmCo-unsplash.jpg\",\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/careerkarma.com\/blog\/sql-having\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-having\/\",\"url\":\"https:\/\/careerkarma.com\/blog\/sql-having\/\",\"name\":\"SQL Having: is a subquery on top of an initial query\",\"isPartOf\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-having\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-having\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/05\/caspar-camille-rubin-fPkvU7RDmCo-unsplash.jpg\",\"datePublished\":\"2020-08-06T07:24:38+00:00\",\"dateModified\":\"2020-12-29T14:39:55+00:00\",\"author\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/ae0cdc4a5d198690d78482646894074e\"},\"description\":\"The SQL HAVING clause allows us to perform aggregate functions in our SQL queries. Learn more about it with this article from Career Karma.\",\"breadcrumb\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-having\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/careerkarma.com\/blog\/sql-having\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-having\/#primaryimage\",\"url\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/05\/caspar-camille-rubin-fPkvU7RDmCo-unsplash.jpg\",\"contentUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/05\/caspar-camille-rubin-fPkvU7RDmCo-unsplash.jpg\",\"width\":1020,\"height\":680,\"caption\":\"Coding SQL in a PHP file on a laptop\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-having\/#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 Having\"}]},{\"@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\/ae0cdc4a5d198690d78482646894074e\",\"name\":\"Christina Kopecky\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/06\/image-3-150x150.jpg\",\"contentUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/06\/image-3-150x150.jpg\",\"caption\":\"Christina Kopecky\"},\"description\":\"Christina is an experienced technical writer, covering topics as diverse as Java, SQL, Python, and web development. She earned her Master of Music in flute performance from the University of Kansas and a bachelor's degree in music with minors in French and mass communication from Southeast Missouri State. Prior to joining the Career Karma team in June 2020, Christina was a teaching assistant, team lead, and section lead at Lambda School, where she led student groups, performed code and project reviews, and debugged problems for students. Christina's technical content is featured frequently in publications like Codecademy, Repl.it, and Educative.\",\"sameAs\":[\"http:\/\/www.linkedin.com\/in\/cmvnk\"],\"url\":\"https:\/\/careerkarma.com\/blog\/author\/christina-kopecky\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Having: is a subquery on top of an initial query","description":"The SQL HAVING clause allows us to perform aggregate functions in our SQL queries. Learn more about it with this article from Career Karma.","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-having\/","og_locale":"en_US","og_type":"article","og_title":"SQL Having","og_description":"The SQL HAVING clause allows us to perform aggregate functions in our SQL queries. Learn more about it with this article from Career Karma.","og_url":"https:\/\/careerkarma.com\/blog\/sql-having\/","og_site_name":"Career Karma","article_publisher":"http:\/\/facebook.com\/careerkarmaapp","article_published_time":"2020-08-06T07:24:38+00:00","article_modified_time":"2020-12-29T14:39:55+00:00","og_image":[{"width":1020,"height":680,"url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/05\/caspar-camille-rubin-fPkvU7RDmCo-unsplash.jpg","type":"image\/jpeg"}],"author":"Christina Kopecky","twitter_card":"summary_large_image","twitter_creator":"@career_karma","twitter_site":"@career_karma","twitter_misc":{"Written by":"Christina Kopecky","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/careerkarma.com\/blog\/sql-having\/#article","isPartOf":{"@id":"https:\/\/careerkarma.com\/blog\/sql-having\/"},"author":{"name":"Christina Kopecky","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/ae0cdc4a5d198690d78482646894074e"},"headline":"SQL Having","datePublished":"2020-08-06T07:24:38+00:00","dateModified":"2020-12-29T14:39:55+00:00","mainEntityOfPage":{"@id":"https:\/\/careerkarma.com\/blog\/sql-having\/"},"wordCount":288,"commentCount":0,"image":{"@id":"https:\/\/careerkarma.com\/blog\/sql-having\/#primaryimage"},"thumbnailUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/05\/caspar-camille-rubin-fPkvU7RDmCo-unsplash.jpg","articleSection":["SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/careerkarma.com\/blog\/sql-having\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/careerkarma.com\/blog\/sql-having\/","url":"https:\/\/careerkarma.com\/blog\/sql-having\/","name":"SQL Having: is a subquery on top of an initial query","isPartOf":{"@id":"https:\/\/careerkarma.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/careerkarma.com\/blog\/sql-having\/#primaryimage"},"image":{"@id":"https:\/\/careerkarma.com\/blog\/sql-having\/#primaryimage"},"thumbnailUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/05\/caspar-camille-rubin-fPkvU7RDmCo-unsplash.jpg","datePublished":"2020-08-06T07:24:38+00:00","dateModified":"2020-12-29T14:39:55+00:00","author":{"@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/ae0cdc4a5d198690d78482646894074e"},"description":"The SQL HAVING clause allows us to perform aggregate functions in our SQL queries. Learn more about it with this article from Career Karma.","breadcrumb":{"@id":"https:\/\/careerkarma.com\/blog\/sql-having\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/careerkarma.com\/blog\/sql-having\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/careerkarma.com\/blog\/sql-having\/#primaryimage","url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/05\/caspar-camille-rubin-fPkvU7RDmCo-unsplash.jpg","contentUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/05\/caspar-camille-rubin-fPkvU7RDmCo-unsplash.jpg","width":1020,"height":680,"caption":"Coding SQL in a PHP file on a laptop"},{"@type":"BreadcrumbList","@id":"https:\/\/careerkarma.com\/blog\/sql-having\/#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 Having"}]},{"@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\/ae0cdc4a5d198690d78482646894074e","name":"Christina Kopecky","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/06\/image-3-150x150.jpg","contentUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/06\/image-3-150x150.jpg","caption":"Christina Kopecky"},"description":"Christina is an experienced technical writer, covering topics as diverse as Java, SQL, Python, and web development. She earned her Master of Music in flute performance from the University of Kansas and a bachelor's degree in music with minors in French and mass communication from Southeast Missouri State. Prior to joining the Career Karma team in June 2020, Christina was a teaching assistant, team lead, and section lead at Lambda School, where she led student groups, performed code and project reviews, and debugged problems for students. Christina's technical content is featured frequently in publications like Codecademy, Repl.it, and Educative.","sameAs":["http:\/\/www.linkedin.com\/in\/cmvnk"],"url":"https:\/\/careerkarma.com\/blog\/author\/christina-kopecky\/"}]}},"_links":{"self":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts\/20864","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\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/comments?post=20864"}],"version-history":[{"count":0,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts\/20864\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/media\/15988"}],"wp:attachment":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/media?parent=20864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/categories?post=20864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/tags?post=20864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}