{"id":174126,"date":"2023-11-27T15:05:15","date_gmt":"2023-11-27T14:05:15","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=174126"},"modified":"2023-11-27T15:07:29","modified_gmt":"2023-11-27T14:07:29","slug":"sql-case-what-is-this-query-and-how-do-i-use-it","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/sql-case-what-is-this-query-and-how-do-i-use-it","title":{"rendered":"SQL CASE: What is this query and how do I use it?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"174126\" class=\"elementor elementor-174126\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-164474e e-flex e-con-boxed e-con\" data-id=\"164474e\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b4290aa elementor-widget elementor-widget-heading\" data-id=\"b4290aa\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">SQL programming language is a valuable tool for developers and experts. Thanks to a multitude of queries, it is possible to manipulate data and relational databases. Among the essential commands, there is SQL CASE. What is this query used for? And how to use it? Discover the answers in this article.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-0be1621 e-flex e-con-boxed e-con\" data-id=\"0be1621\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d5eac9a elementor-widget elementor-widget-heading\" data-id=\"d5eac9a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Case SQL : What is this query and how do I use it?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-986c1a1 elementor-widget elementor-widget-text-editor\" data-id=\"986c1a1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>In computer language, the CASE\/WHEN command serves the same purpose as the IF\/ELSE function. Namely, to return a result from among several possibilities.<\/p><p>Depending on the syntax used, CASE can be used to :<\/p><p><strong>1\u00ba Compare data with a set of possible results. In this case, here&#8217;s the CASE SQL syntax:<\/strong><\/p><p>CASE<\/p><p>WHEN expression THEN result<\/p><p>ELSE other result<\/p><p>END<\/p><p><strong>2 \u00ba Determine a result by constructing several Boolean expressions (true or false). The syntax is as follows:<\/strong><\/p><p>CASE<\/p><p>WHEN Boolean expression THEN result<\/p><p>ELSE other result<\/p><p>END<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ec1fd74 elementor-widget elementor-widget-text-editor\" data-id=\"ec1fd74\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Good to know: in both cases, the ELSE clause is optional. This allows you to define a value in case the WHEN conditions are not met.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-eeed633 elementor-widget elementor-widget-text-editor\" data-id=\"eeed633\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Beyond these simplified syntaxes, the SQL CASE query is often used with other commands.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3f1d3d4 e-flex e-con-boxed e-con\" data-id=\"3f1d3d4\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-580b1c5 elementor-widget elementor-widget-heading\" data-id=\"580b1c5\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What are the other commands to use with SQL CASE?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aecdd79 elementor-widget elementor-widget-text-editor\" data-id=\"aecdd79\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>To enrich the database, the SQL CASE query can be used <a href=\"https:\/\/datascientest.com\/en\/sql-queries-the-5-most-important-commands-to-know\">with other commands.<\/a> Here are the main ones and their different functionalities:<\/p><p>SELECT: This is one of the most common SQL queries. It allows you to select columns within a table.<br \/>UPDATE: This command is used to update a column.<br \/><a href=\"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query\">DELETE<\/a>: It is used to delete one or more rows.<br \/>ORDER BY: This query is used to sort the data in the table (ascending or descending order).<br \/>GROUP BY: This allows you to group data based on a defined condition.<br \/><a href=\"https:\/\/datascientest.com\/en\/sql-insert-into-insert-data-with-this-sql-query\">INSERT INTO<\/a>: If you want to add more information to your data table.<br \/>SUM: It is used to calculate sums (of a product, a price, etc.).<br \/>HAVING: To restrict rows.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a5698f5 elementor-widget elementor-widget-text-editor\" data-id=\"a5698f5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>That being said, we will now see some concrete usage examples.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3be985a elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"3be985a\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-courses\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn to use CASE SQL<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-de0bb65 e-flex e-con-boxed e-con\" data-id=\"de0bb65\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-28df33a elementor-widget elementor-widget-heading\" data-id=\"28df33a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">3 examples of using CASE SQL <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1953deb elementor-widget elementor-widget-text-editor\" data-id=\"1953deb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>To help you better understand the use of SQL CASE, here are several concrete examples.<\/p><p>For each of them, we will use this &#8220;Purchase&#8221; table. The company&#8217;s goal is to determine the right price. To do this, it relies on the achieved profit margin.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fa27d99 elementor-widget elementor-widget-html\" data-id=\"fa27d99\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg  {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-hav4{background-color:#656565;border-color:inherit;color:#efefef;font-size:20px;text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\n<colgroup>\n<col style=\"width: 30px\">\n<col style=\"width: 150px\">\n<col style=\"width: 100.66px\">\n<col style=\"width: 100.66px\">\n<col style=\"width: 118.66px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-hav4\">ID<\/th>\n    <th class=\"tg-hav4\">Product Name<\/th>\n    <th class=\"tg-hav4\">Margin<\/th>\n    <th class=\"tg-hav4\">Quantity<\/th>\n    <th class=\"tg-hav4\">Unit Price<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-hav4\">1<\/td>\n    <td class=\"tg-c3ow\">Product 1<\/td>\n    <td class=\"tg-c3ow\">1<\/td>\n    <td class=\"tg-c3ow\">1<\/td>\n    <td class=\"tg-c3ow\">50<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-hav4\">2<\/td>\n    <td class=\"tg-c3ow\">Product 2<\/td>\n    <td class=\"tg-c3ow\">1.25<\/td>\n    <td class=\"tg-c3ow\">3<\/td>\n    <td class=\"tg-c3ow\">70<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-hav4\">3<\/td>\n    <td class=\"tg-c3ow\">Product 3<\/td>\n    <td class=\"tg-c3ow\">0.75<\/td>\n    <td class=\"tg-c3ow\">2<\/td>\n    <td class=\"tg-c3ow\">60<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-hav4\">4<\/td>\n    <td class=\"tg-c3ow\">Product 4<\/td>\n    <td class=\"tg-c3ow\">1.5<\/td>\n    <td class=\"tg-c3ow\">2<\/td>\n    <td class=\"tg-c3ow\">80<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b675e0a elementor-widget elementor-widget-heading\" data-id=\"b675e0a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Personalized message<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c57e571 elementor-widget elementor-widget-text-editor\" data-id=\"c57e571\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The goal is to inform decision-makers about the pricing positioning of each product. To achieve this, you can use the SQL CASE query.<\/p><p>Here is the syntax:<\/p><p>SELECT id, product name, margin, quantity, unit price,<br \/>CASE<br \/>WHEN margin &gt; 1 THEN &#8216;High Price&#8217;<br \/>WHEN margin &lt; 1 THEN &#8216;Low Price&#8217;<br \/>ELSE &#8216;Normal Price&#8217;<br \/>END<br \/>FROM `Purchase`<\/p><p>And the result:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8a48d9f elementor-widget elementor-widget-html\" data-id=\"8a48d9f\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg  {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-hav4{background-color:#656565;border-color:inherit;color:#efefef;font-size:20px;text-align:center;vertical-align:top}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-i3d5{background-color:#656565;color:#efefef;font-size:20px;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 600px\">\n<colgroup>\n<col style=\"width: 30px\">\n<col style=\"width: 150px\">\n<col style=\"width: 100.66px\">\n<col style=\"width: 100.66px\">\n<col style=\"width: 118.66px\">\n<col style=\"width: 100px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-hav4\">ID<\/th>\n    <th class=\"tg-hav4\">Product Name<\/th>\n    <th class=\"tg-hav4\">Margin<\/th>\n    <th class=\"tg-hav4\">Quantity<\/th>\n    <th class=\"tg-hav4\">Unit Price<\/th>\n    <th class=\"tg-i3d5\">CASE<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-hav4\">1<\/td>\n    <td class=\"tg-c3ow\">Product 1<\/td>\n    <td class=\"tg-c3ow\">1<\/td>\n    <td class=\"tg-c3ow\">1<\/td>\n    <td class=\"tg-c3ow\">50<\/td>\n    <td class=\"tg-baqh\">Normal Price<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-hav4\">2<\/td>\n    <td class=\"tg-c3ow\">Product 2<\/td>\n    <td class=\"tg-c3ow\">1.25<\/td>\n    <td class=\"tg-c3ow\">3<\/td>\n    <td class=\"tg-c3ow\">70<\/td>\n    <td class=\"tg-baqh\">High Price<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-hav4\">3<\/td>\n    <td class=\"tg-c3ow\">Product 3<\/td>\n    <td class=\"tg-c3ow\">0.75<\/td>\n    <td class=\"tg-c3ow\">2<\/td>\n    <td class=\"tg-c3ow\">60<\/td>\n    <td class=\"tg-baqh\">Low Price<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-hav4\">4<\/td>\n    <td class=\"tg-c3ow\">Product 4<\/td>\n    <td class=\"tg-c3ow\">1.5<\/td>\n    <td class=\"tg-c3ow\">2<\/td>\n    <td class=\"tg-c3ow\">80<\/td>\n    <td class=\"tg-baqh\">High Price<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b56b7bf elementor-widget elementor-widget-heading\" data-id=\"b56b7bf\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Unit price change<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a3e6f93 elementor-widget elementor-widget-text-editor\" data-id=\"a3e6f93\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>To adjust its pricing policy, the company wishes to modify its prices based on its margin: reduce by 10% when the margin is positive and increase by 10% when it is negative.<\/p><p>Once again, the use of conditions and the SQL CASE command allows for quick modification of the database.<\/p><p>Here is the syntax:<\/p><p>SELECT id, product name, margin, quantity, unit price,<br \/>CASE<br \/>WHEN margin &gt; 1 THEN prix unitaire * 0.9<br \/>WHEN margin &lt; 1 THEN prix unitaire * 1.1<br \/>ELSE unit price<br \/>END<br \/>FROM `Purchase`<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2253286 elementor-widget elementor-widget-html\" data-id=\"2253286\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg  {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-hav4{background-color:#656565;border-color:inherit;color:#efefef;font-size:20px;text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\n<colgroup>\n<col style=\"width: 30px\">\n<col style=\"width: 150px\">\n<col style=\"width: 100.66px\">\n<col style=\"width: 100.66px\">\n<col style=\"width: 118.66px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-hav4\">ID<\/th>\n    <th class=\"tg-hav4\">Product Name<\/th>\n    <th class=\"tg-hav4\">Margin<\/th>\n    <th class=\"tg-hav4\">Quantity<\/th>\n    <th class=\"tg-hav4\">Unit Price<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-hav4\">1<\/td>\n    <td class=\"tg-c3ow\">Product 1<\/td>\n    <td class=\"tg-c3ow\">1<\/td>\n    <td class=\"tg-c3ow\">1<\/td>\n    <td class=\"tg-c3ow\">50<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-hav4\">2<\/td>\n    <td class=\"tg-c3ow\">Product 2<\/td>\n    <td class=\"tg-c3ow\">1.25<\/td>\n    <td class=\"tg-c3ow\">3<\/td>\n    <td class=\"tg-c3ow\">63<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-hav4\">3<\/td>\n    <td class=\"tg-c3ow\">Product 3<\/td>\n    <td class=\"tg-c3ow\">0.75<\/td>\n    <td class=\"tg-c3ow\">2<\/td>\n    <td class=\"tg-c3ow\">66<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-hav4\">4<\/td>\n    <td class=\"tg-c3ow\">Product 4<\/td>\n    <td class=\"tg-c3ow\">1.5<\/td>\n    <td class=\"tg-c3ow\">2<\/td>\n    <td class=\"tg-c3ow\">72<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2fa2f15 elementor-widget elementor-widget-heading\" data-id=\"2fa2f15\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Quantity update<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a398f15 elementor-widget elementor-widget-text-editor\" data-id=\"a398f15\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>In addition to SELECT, the CASE SQL query can also be used with other commands, such as UPDATE.<\/p><p>To help you visualize this query, here&#8217;s a hypothetical scenario.<\/p><p>For every product with a positive margin, the company offers an additional product. In this case, you&#8217;ll need to update the table.<\/p><p>Here&#8217;s how to do it:<\/p><p>UPDATE `purchase<\/p><p>SET `quantity` = (<\/p><p>CASE<\/p><p>WHEN margin &gt; 1 THEN &#8216;Quantity + 1&#8217;.<\/p><p>ELSE &#8216;Quantity<\/p><p>END<\/p><p>)<\/p><p>And the result:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-065d1b1 elementor-widget elementor-widget-html\" data-id=\"065d1b1\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg  {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-hav4{background-color:#656565;border-color:inherit;color:#efefef;font-size:20px;text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\n<colgroup>\n<col style=\"width: 30px\">\n<col style=\"width: 150px\">\n<col style=\"width: 100.66px\">\n<col style=\"width: 100.66px\">\n<col style=\"width: 118.66px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-hav4\">ID<\/th>\n    <th class=\"tg-hav4\">Product Name<\/th>\n    <th class=\"tg-hav4\">Margin<\/th>\n    <th class=\"tg-hav4\">Quantity<\/th>\n    <th class=\"tg-hav4\">Unit Price<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-hav4\">1<\/td>\n    <td class=\"tg-c3ow\">Product 1<\/td>\n    <td class=\"tg-c3ow\">1<\/td>\n    <td class=\"tg-c3ow\">1<\/td>\n    <td class=\"tg-c3ow\">50<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-hav4\">2<\/td>\n    <td class=\"tg-c3ow\">Product 2<\/td>\n    <td class=\"tg-c3ow\">1.25<\/td>\n    <td class=\"tg-c3ow\">4<\/td>\n    <td class=\"tg-c3ow\">70<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-hav4\">3<\/td>\n    <td class=\"tg-c3ow\">Product 3<\/td>\n    <td class=\"tg-c3ow\">0.75<\/td>\n    <td class=\"tg-c3ow\">2<\/td>\n    <td class=\"tg-c3ow\">60<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-hav4\">4<\/td>\n    <td class=\"tg-c3ow\">Product 4<\/td>\n    <td class=\"tg-c3ow\">1.5<\/td>\n    <td class=\"tg-c3ow\">3<\/td>\n    <td class=\"tg-c3ow\">80<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f604c2a elementor-widget elementor-widget-text-editor\" data-id=\"f604c2a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>These are just a few simplified examples. If you&#8217;d like to find out more about the various use cases for CASE SQL queries, take our training course at DataScientest.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8505fab e-flex e-con-boxed e-con\" data-id=\"8505fab\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1e4eb5e elementor-widget elementor-widget-heading\" data-id=\"1e4eb5e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Develop your computer language skills with DataScientest<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0ef122c elementor-widget elementor-widget-text-editor\" data-id=\"0ef122c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Beyond the CASE SQL query, the structured query language is packed with a multitude of commands for <a href=\"https:\/\/datascientest.com\/en\/open-sql-file-complete-tutorial\">manipulating databases.<\/a> To master them all, training is essential. That&#8217;s why we offer a range of training courses at Datascientest.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d73d018 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"d73d018\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-courses\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Become a SQL expert with DataScientest<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-2053a68 e-flex e-con-boxed e-con\" data-id=\"2053a68\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-462bdd9 elementor-widget elementor-widget-html\" data-id=\"462bdd9\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"What is the CASE command?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"In computer language, the CASE\/WHEN command serves the same purpose as the IF\/ELSE function. Namely, to return a result among several possibilities.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"3 examples of how to use CASE SQL\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"To help you better understand the use of CASE SQL, here are several concrete examples. For each of them, we'll use this \"Purchase\" table. The company's objective is to define the right price. To do this, it bases itself on the margin rate achieved.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Unit price modification\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"In order to adjust its pricing policy, the company wishes to modify its prices according to its margin: reduce by 10% when the margin is positive, and increase by 10% when it is negative. Here again, the use of conditions and the CASE SQL command make it possible to quickly modify the database.\"\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>SQL programming language is a valuable tool for developers and experts. Thanks to a multitude of queries, it is possible to manipulate data and relational databases. Among the essential commands, there is SQL CASE. What is this query used for? And how to use it? Discover the answers in this article. Case SQL : What [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":174128,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL CASE: What is this query and how do I use it?<\/title>\n<meta name=\"description\" content=\"A SQL CASE query is used to perform conditional logic within a SQL query. It allows you to execute different...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/sql-case-what-is-this-query-and-how-do-i-use-it\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL CASE: What is this query and how do I use it?\" \/>\n<meta property=\"og:description\" content=\"SQL programming language is a valuable tool for developers and experts. Thanks to a multitude of queries, it is possible to manipulate data and relational\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/sql-case-what-is-this-query-and-how-do-i-use-it\" \/>\n<meta property=\"og:site_name\" content=\"DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-27T14:05:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-27T14:07:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/requete_sql_case-1024x512-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated 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:\/\/datascientest.com\/en\/sql-case-what-is-this-query-and-how-do-i-use-it#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/sql-case-what-is-this-query-and-how-do-i-use-it\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"SQL CASE: What is this query and how do I use it?\",\"datePublished\":\"2023-11-27T14:05:15+00:00\",\"dateModified\":\"2023-11-27T14:07:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/sql-case-what-is-this-query-and-how-do-i-use-it\"},\"wordCount\":736,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/sql-case-what-is-this-query-and-how-do-i-use-it#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/sql-case-what-is-this-query-and-how-do-i-use-it\",\"url\":\"https:\/\/datascientest.com\/en\/sql-case-what-is-this-query-and-how-do-i-use-it\",\"name\":\"SQL CASE: What is this query and how do I use it?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2023-11-27T14:05:15+00:00\",\"dateModified\":\"2023-11-27T14:07:29+00:00\",\"description\":\"A SQL CASE query is used to perform conditional logic within a SQL query. It allows you to execute different...\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/sql-case-what-is-this-query-and-how-do-i-use-it\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL CASE: What is this query and how do I use it?","description":"A SQL CASE query is used to perform conditional logic within a SQL query. It allows you to execute different...","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:\/\/datascientest.com\/en\/sql-case-what-is-this-query-and-how-do-i-use-it","og_locale":"en_GB","og_type":"article","og_title":"SQL CASE: What is this query and how do I use it?","og_description":"SQL programming language is a valuable tool for developers and experts. Thanks to a multitude of queries, it is possible to manipulate data and relational","og_url":"https:\/\/datascientest.com\/en\/sql-case-what-is-this-query-and-how-do-i-use-it","og_site_name":"DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2023-11-27T14:05:15+00:00","article_modified_time":"2023-11-27T14:07:29+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/datascientest.com\/en\/files\/2023\/11\/requete_sql_case-1024x512-1.png","type":"image\/png"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/sql-case-what-is-this-query-and-how-do-i-use-it#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/sql-case-what-is-this-query-and-how-do-i-use-it"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"SQL CASE: What is this query and how do I use it?","datePublished":"2023-11-27T14:05:15+00:00","dateModified":"2023-11-27T14:07:29+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/sql-case-what-is-this-query-and-how-do-i-use-it"},"wordCount":736,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/sql-case-what-is-this-query-and-how-do-i-use-it#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/sql-case-what-is-this-query-and-how-do-i-use-it","url":"https:\/\/datascientest.com\/en\/sql-case-what-is-this-query-and-how-do-i-use-it","name":"SQL CASE: What is this query and how do I use it?","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2023-11-27T14:05:15+00:00","dateModified":"2023-11-27T14:07:29+00:00","description":"A SQL CASE query is used to perform conditional logic within a SQL query. It allows you to execute different...","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/sql-case-what-is-this-query-and-how-do-i-use-it"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/174126"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=174126"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/174126\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/174128"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=174126"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=174126"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=174126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}