{"id":175676,"date":"2024-01-04T17:33:57","date_gmt":"2024-01-04T16:33:57","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=175676"},"modified":"2024-01-04T17:37:08","modified_gmt":"2024-01-04T16:37:08","slug":"sql-group-by-everything-you-need-to-know-about-this-query","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/sql-group-by-everything-you-need-to-know-about-this-query","title":{"rendered":"SQL GROUP BY: Everything you need to know about this query"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"175676\" class=\"elementor elementor-175676\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-27a8adb e-flex e-con-boxed e-con\" data-id=\"27a8adb\" 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-8347db3 elementor-widget elementor-widget-heading\" data-id=\"8347db3\" 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\">One of the most useful SQL commands for data analysts is GROUP BY. It allows you to easily generate advanced statistics from categories. Suffice to say, it's one of the 10 commands you'll use the most, so you might as well know what it's all about.<\/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-f0745d5 e-flex e-con-boxed e-con\" data-id=\"f0745d5\" 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-9131ea2 elementor-widget elementor-widget-text-editor\" data-id=\"9131ea2\" 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><a href=\"https:\/\/datascientest.com\/en\/sql-queries-the-5-most-important-commands-to-know\">SQL&#8217;s strengths<\/a> are well established. This language offers an unrivalled level of abstraction for analyzing vast volumes of information. Whatever the database software used (<a href=\"https:\/\/datascientest.com\/en\/demystifying-mysql-a-comprehensive-guide-to-relational-data-managemen\">MySQL<\/a>, Ingres, Oracle Database, <strong>Microsoft SQL Server,<\/strong> PostgreSQL, SQLite, Firebird&#8230;), the data analyst knows he&#8217;ll get the desired result without having to program the precise logic.<\/p><p>\u00a0<\/p><p>\ud83d\udca1Related articles:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" data-sheets-root=\"1\"><colgroup><col width=\"656\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL DELETE: How do I use this query?&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query\" target=\"_blank\" rel=\"noopener\">SQL DELETE: How do I use this query?<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Developer: What is it? What's it for?&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-developer-what-is-it-whats-it-for\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-developer-what-is-it-whats-it-for\" target=\"_blank\" rel=\"noopener\">SQL Developer: What is it? What&#8217;s it for?<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Tutorial: Top 5 Most Useful Methods&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\" target=\"_blank\" rel=\"noopener\">SQL Tutorial: Top 5 Most Useful Methods<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL joins: everything you need to know about table associations&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-joins-everything-you-need-to-know-about\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-joins-everything-you-need-to-know-about\" target=\"_blank\" rel=\"noopener\">SQL joins: everything you need to know about table associations<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL vs NoSQL: differences, uses, advantages and disadvantages&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-vs-nosql\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-vs-nosql\" target=\"_blank\" rel=\"noopener\">SQL vs NoSQL: differences, uses, advantages and disadvantages<\/a><\/td><\/tr><\/tbody><\/table>\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-5e55046 e-flex e-con-boxed e-con\" data-id=\"5e55046\" 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-32490eb elementor-widget elementor-widget-heading\" data-id=\"32490eb\" 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\">How do you group information in a database?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-625fb3f elementor-widget elementor-widget-text-editor\" data-id=\"625fb3f\" 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>If there&#8217;s one particularly important command you&#8217;ll appreciate, it&#8217;s <strong>SQL GROUP BY<\/strong>. It groups information from a database according to a particular column, from which it is possible to obtain statistical information: sum, maximum, minimum, average, etc.<\/p><p>To better understand this concept, it&#8217;s best to start with an example. Here&#8217;s an extract from a table called Staff<\/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-a256cfe elementor-widget elementor-widget-html\" data-id=\"a256cfe\" 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-8a1x{background-color:#6665cd;color:#efefef;font-family:Tahoma, Geneva, sans-serif !important;font-size:20px;\n    font-weight:bold;text-align:center;vertical-align:top}\n  .tg .tg-r3ey{font-family:Tahoma, Geneva, sans-serif !important;font-size:100%;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 300px\">\n  <colgroup>\n    <col style=\"width: 100px\">\n    <col style=\"width: 100px\">\n    <col style=\"width: 100px\">\n  <\/colgroup>\n  <thead>\n    <tr>\n      <th class=\"tg-8a1x\">Name<\/th>\n      <th class=\"tg-8a1x\">Department<\/th>\n      <th class=\"tg-8a1x\">Salary<\/th>\n    <\/tr>\n  <\/thead>\n  <tbody>\n    <tr>\n      <td class=\"tg-r3ey\">Paul<\/td>\n      <td class=\"tg-r3ey\">Finance<\/td>\n      <td class=\"tg-r3ey\">$3,000<\/td>\n    <\/tr>\n    <tr>\n      <td class=\"tg-r3ey\">Ray<\/td>\n      <td class=\"tg-r3ey\">Sales<\/td>\n      <td class=\"tg-r3ey\">$2,500<\/td>\n    <\/tr>\n    <tr>\n      <td class=\"tg-r3ey\">Julia<\/td>\n      <td class=\"tg-r3ey\">Finance<\/td>\n      <td class=\"tg-r3ey\">$3,200<\/td>\n    <\/tr>\n    <tr>\n      <td class=\"tg-r3ey\">Dan<\/td>\n      <td class=\"tg-r3ey\">Marketing<\/td>\n      <td class=\"tg-r3ey\">$4,300<\/td>\n    <\/tr>\n    <tr>\n      <td class=\"tg-r3ey\">Josie<\/td>\n      <td class=\"tg-r3ey\">Sales<\/td>\n      <td class=\"tg-r3ey\">$2,200<\/td>\n    <\/tr>\n    <tr>\n      <td class=\"tg-r3ey\">Donna<\/td>\n      <td class=\"tg-r3ey\">Finance<\/td>\n      <td class=\"tg-r3ey\">$2,700<\/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-2f0fd5d elementor-widget elementor-widget-text-editor\" data-id=\"2f0fd5d\" 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>If we wanted to obtain the sum of <strong>salaries by department,<\/strong> we&#8217;d simply use a sequence like the following:<\/p><p>SELECT Department, SUM(Salary)<\/p><p>FROM Staff<\/p><p>GROUP BY Service<\/p><p>ORDER BY Service;<\/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-880c920 elementor-widget elementor-widget-text-editor\" data-id=\"880c920\" 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 this example, we group the table according to the Service column and ask for the sum of salaries for each of them.<\/p><p>The answer would be &#8211; based on the sample shown above :<\/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-e7af1c8 elementor-widget elementor-widget-html\" data-id=\"e7af1c8\" 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-r3ey{font-family:Tahoma, Geneva, sans-serif !important;font-size:100%;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout : fixed ; width : 200px\">\n<colgroup>\n<col style=\"width : 100px\">\n<col style=\"width : 100px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-r3ey\">Finances<\/th>\n    <th class=\"tg-r3ey\">8 900<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-r3ey\">Marketing<\/td>\n    <td class=\"tg-r3ey\">4 300<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-r3ey\">Sales<\/td>\n    <td class=\"tg-r3ey\">4 700<\/td>\n  <\/tr>\n<\/tbody>\n<\/tableau>\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-3ee54ec e-flex e-con-boxed e-con\" data-id=\"3ee54ec\" 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-bf165f7 elementor-widget elementor-widget-heading\" data-id=\"bf165f7\" 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\">How do I use the HAVING BY clause?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7956ebd elementor-widget elementor-widget-text-editor\" data-id=\"7956ebd\" 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><strong>HAVING BY<\/strong> completes the <strong>SQL GROUP BY<\/strong> command by opening up the possibility of specifying a condition. In the example below, we&#8217;d like to display the average salary (the AVG function), but only if this average is greater than 2500:<\/p><p>SELECT Department, AVG(Salary)<\/p><p>FROM Personnel<\/p><p>GROUP BY Service<\/p><p>HAVING AVG(Salary) &gt; 2500<\/p><p>ORDER BY Service;<\/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-7200716 elementor-widget elementor-widget-text-editor\" data-id=\"7200716\" 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 result is :<\/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-9471e13 elementor-widget elementor-widget-html\" data-id=\"9471e13\" 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\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-r3ey{font-family:Tahoma, Geneva, sans-serif !important;font-size:100%;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 200px\">\r\n<colgroup>\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-r3ey\">Finances<\/th>\r\n    <th class=\"tg-r3ey\">2 967<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-r3ey\">Marketing<\/td>\r\n    <td class=\"tg-r3ey\">4 300<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5100556 elementor-widget elementor-widget-text-editor\" data-id=\"5100556\" 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>And that&#8217;s it! It&#8217;s that simple. The ease with which such operations can be implemented is a testament to the qualities of the <a href=\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\">SQL language.<\/a><\/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-62cbab4 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"62cbab4\" 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-scientist-course\">\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\">Training in SQL for data<\/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\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>One of the most useful SQL commands for data analysts is GROUP BY. It allows you to easily generate advanced statistics from categories. Suffice to say, it&#8217;s one of the 10 commands you&#8217;ll use the most, so you might as well know what it&#8217;s all about. SQL&#8217;s strengths are well established. This language offers an [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":175678,"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 GROUP BY: Everything you need to know about this query<\/title>\n<meta name=\"description\" content=\"The SQL GROUP BY clause in SQL is used to group rows that have the same values in specified columns into summary rows, like &quot;total&quot; or &quot;average.&quot; It is often used in\" \/>\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-group-by-everything-you-need-to-know-about-this-query\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL GROUP BY: Everything you need to know about this query\" \/>\n<meta property=\"og:description\" content=\"One of the most useful SQL commands for data analysts is GROUP BY. It allows you to easily generate advanced statistics from categories. Suffice to say,\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/sql-group-by-everything-you-need-to-know-about-this-query\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-04T16:33:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-04T16:37:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/01\/sql-group-by-datascientest.webp\" \/>\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\/webp\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/sql-group-by-everything-you-need-to-know-about-this-query#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/sql-group-by-everything-you-need-to-know-about-this-query\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"SQL GROUP BY: Everything you need to know about this query\",\"datePublished\":\"2024-01-04T16:33:57+00:00\",\"dateModified\":\"2024-01-04T16:37:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/sql-group-by-everything-you-need-to-know-about-this-query\"},\"wordCount\":394,\"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-group-by-everything-you-need-to-know-about-this-query#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/sql-group-by-everything-you-need-to-know-about-this-query\",\"url\":\"https:\/\/datascientest.com\/en\/sql-group-by-everything-you-need-to-know-about-this-query\",\"name\":\"SQL GROUP BY: Everything you need to know about this query\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-01-04T16:33:57+00:00\",\"dateModified\":\"2024-01-04T16:37:08+00:00\",\"description\":\"The SQL GROUP BY clause in SQL is used to group rows that have the same values in specified columns into summary rows, like \\\"total\\\" or \\\"average.\\\" It is often used in\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/sql-group-by-everything-you-need-to-know-about-this-query\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | 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 GROUP BY: Everything you need to know about this query","description":"The SQL GROUP BY clause in SQL is used to group rows that have the same values in specified columns into summary rows, like \"total\" or \"average.\" It is often used in","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-group-by-everything-you-need-to-know-about-this-query","og_locale":"en_GB","og_type":"article","og_title":"SQL GROUP BY: Everything you need to know about this query","og_description":"One of the most useful SQL commands for data analysts is GROUP BY. It allows you to easily generate advanced statistics from categories. Suffice to say,","og_url":"https:\/\/datascientest.com\/en\/sql-group-by-everything-you-need-to-know-about-this-query","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-01-04T16:33:57+00:00","article_modified_time":"2024-01-04T16:37:08+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/datascientest.com\/en\/files\/2024\/01\/sql-group-by-datascientest.webp","type":"image\/webp"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/sql-group-by-everything-you-need-to-know-about-this-query#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/sql-group-by-everything-you-need-to-know-about-this-query"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"SQL GROUP BY: Everything you need to know about this query","datePublished":"2024-01-04T16:33:57+00:00","dateModified":"2024-01-04T16:37:08+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/sql-group-by-everything-you-need-to-know-about-this-query"},"wordCount":394,"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-group-by-everything-you-need-to-know-about-this-query#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/sql-group-by-everything-you-need-to-know-about-this-query","url":"https:\/\/datascientest.com\/en\/sql-group-by-everything-you-need-to-know-about-this-query","name":"SQL GROUP BY: Everything you need to know about this query","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-01-04T16:33:57+00:00","dateModified":"2024-01-04T16:37:08+00:00","description":"The SQL GROUP BY clause in SQL is used to group rows that have the same values in specified columns into summary rows, like \"total\" or \"average.\" It is often used in","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/sql-group-by-everything-you-need-to-know-about-this-query"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | 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\/175676"}],"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=175676"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/175676\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/175678"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=175676"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=175676"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=175676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}