{"id":986,"date":"2024-05-14T20:50:56","date_gmt":"2024-05-14T23:50:56","guid":{"rendered":"https:\/\/thiagorossi.com.br\/blog\/?p=986"},"modified":"2024-12-04T15:05:06","modified_gmt":"2024-12-04T18:05:06","slug":"agregando-dados-no-sql","status":"publish","type":"post","link":"https:\/\/thiagorossi.com.br\/blog\/agregando-dados-no-sql\/","title":{"rendered":"Agregando Dados no SQL"},"content":{"rendered":"<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Tempo de leitura: <\/span> <span class=\"rt-time\"> 3<\/span> <span class=\"rt-label rt-postfix\">minutos<\/span><\/span>\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong>Agregando Dados no SQL:<\/strong> Quando trabalhamos com grandes volumes de dados em bancos de dados relacionais, muitas vezes precisamos resumir e analisar essas informa\u00e7\u00f5es de forma concisa. \u00c9 a\u00ed que as fun\u00e7\u00f5es de agrega\u00e7\u00e3o do SQL entram em cena. Essas fun\u00e7\u00f5es permitem realizar c\u00e1lculos em conjuntos de dados, como somar valores, calcular m\u00e9dias, encontrar valores m\u00e1ximos e m\u00ednimos, e muito mais. <\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Neste artigo, vamos explorar as principais fun\u00e7\u00f5es de agrega\u00e7\u00e3o do SQL e como utiliz\u00e1-las para obter insights valiosos a partir dos seus dados.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-large-font-size\"><strong>O que s\u00e3o fun\u00e7\u00f5es de agrega\u00e7\u00e3o?<\/strong><\/h2>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">As fun\u00e7\u00f5es de agrega\u00e7\u00e3o no SQL s\u00e3o ferramentas poderosas que operam em um conjunto de valores e retornam um \u00fanico valor como resultado. Elas s\u00e3o especialmente \u00fateis para realizar c\u00e1lculos estat\u00edsticos e resumir grandes volumes de dados.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-large-font-size\"><strong>Principais fun\u00e7\u00f5es de agrega\u00e7\u00e3o<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"has-medium-font-size\"><strong>COUNT(*):<\/strong> Conta o n\u00famero total de linhas em um conjunto de resultados.<\/li>\n\n\n\n<li class=\"has-medium-font-size\"><strong>SUM():<\/strong> Calcula a soma dos valores num\u00e9ricos em uma coluna.<\/li>\n\n\n\n<li class=\"has-medium-font-size\"><strong>AVG():<\/strong> Calcula a m\u00e9dia dos valores num\u00e9ricos em uma coluna.<\/li>\n\n\n\n<li class=\"has-medium-font-size\"><strong>MIN():<\/strong> Retorna o menor valor em uma coluna.<\/li>\n\n\n\n<li class=\"has-medium-font-size\"><strong>MAX():<\/strong> Retorna o maior valor em uma coluna.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading has-large-font-size\"><strong>Sintaxe b\u00e1sica<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SQL<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT fun\u00e7\u00e3o_de_agrega\u00e7\u00e3o(coluna)\nFROM tabela;<\/code><\/pre>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong>Exemplo:<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT COUNT(*) FROM clientes;<\/code><\/pre>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Este comando contar\u00e1 o n\u00famero total de clientes na tabela &#8220;clientes&#8221;.<\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading has-large-font-size\"><strong>Agrupando dados com GROUP BY<\/strong><\/h2>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Para realizar c\u00e1lculos em subconjuntos de dados, utilizamos a cl\u00e1usula <code>GROUP BY<\/code>. Ela agrupa os dados de acordo com um ou mais crit\u00e9rios e aplica as fun\u00e7\u00f5es de agrega\u00e7\u00e3o a cada grupo.<\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong>Exemplo:<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT cidade, COUNT(*) AS total_clientes\nFROM clientes\nGROUP BY cidade;<\/code><\/pre>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Este comando agrupa os clientes por cidade e conta quantos clientes existem em cada cidade.<\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading has-large-font-size\"><strong>Combinando fun\u00e7\u00f5es de agrega\u00e7\u00e3o com outras cl\u00e1usulas<\/strong><\/h2>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">As fun\u00e7\u00f5es de agrega\u00e7\u00e3o podem ser combinadas com outras cl\u00e1usulas SQL, como <code>WHERE<\/code>, <code>HAVING<\/code> e <code>ORDER BY<\/code>, para obter resultados mais espec\u00edficos.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"has-medium-font-size\"><strong>WHERE:<\/strong> Filtra os dados antes da aplica\u00e7\u00e3o das fun\u00e7\u00f5es de agrega\u00e7\u00e3o.<\/li>\n\n\n\n<li class=\"has-medium-font-size\"><strong>HAVING:<\/strong> Filtra os grupos ap\u00f3s a aplica\u00e7\u00e3o das fun\u00e7\u00f5es de agrega\u00e7\u00e3o.<\/li>\n\n\n\n<li class=\"has-medium-font-size\"><strong>ORDER BY:<\/strong> Ordena os resultados.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong>Exemplo:<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT pa\u00eds, SUM(valor_venda) AS total_vendas\nFROM pedidos\nWHERE ano = 2023\nGROUP BY pa\u00eds\nHAVING SUM(valor_venda) &gt; 10000\nORDER BY total_vendas DESC;<\/code><\/pre>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Este comando calcula o valor total de vendas por pa\u00eds no ano de 2023, filtra os pa\u00edses com vendas superiores a 10.000 e ordena os resultados em ordem decrescente de vendas.<\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Aplica\u00e7\u00f5es das fun\u00e7\u00f5es de agrega\u00e7\u00e3o<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"has-medium-font-size\"><strong>An\u00e1lise de vendas:<\/strong> Calcular o total de vendas por produto, por vendedor ou por regi\u00e3o.<\/li>\n\n\n\n<li class=\"has-medium-font-size\"><strong>Relat\u00f3rios financeiros:<\/strong> Calcular receitas, custos e lucros.<\/li>\n\n\n\n<li class=\"has-medium-font-size\"><strong>An\u00e1lise de dados demogr\u00e1ficos:<\/strong> Calcular a m\u00e9dia de idade, o n\u00famero de clientes por faixa et\u00e1ria, etc.<\/li>\n\n\n\n<li class=\"has-medium-font-size\"><strong>An\u00e1lise de comportamento do usu\u00e1rio:<\/strong> Calcular o n\u00famero de visitas a um site, a m\u00e9dia de tempo gasto por p\u00e1gina, etc.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading has-large-font-size\"><strong>Considera\u00e7\u00f5es importantes<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"has-medium-font-size\"><strong>Valores nulos:<\/strong> As fun\u00e7\u00f5es de agrega\u00e7\u00e3o geralmente ignoram valores nulos.<\/li>\n\n\n\n<li class=\"has-medium-font-size\"><strong>Fun\u00e7\u00f5es de agrega\u00e7\u00e3o com outras colunas:<\/strong> Ao utilizar fun\u00e7\u00f5es de agrega\u00e7\u00e3o, voc\u00ea s\u00f3 pode selecionar colunas que est\u00e3o sendo agrupadas ou colunas que est\u00e3o dentro de uma fun\u00e7\u00e3o de agrega\u00e7\u00e3o.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading has-large-font-size\"><strong>Conclus\u00e3o<\/strong><\/h2>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong>Agregando Dados no SQL:<\/strong> As fun\u00e7\u00f5es de agrega\u00e7\u00e3o s\u00e3o ferramentas essenciais para qualquer profissional que trabalha com bancos de dados. Elas permitem transformar grandes volumes de dados em informa\u00e7\u00f5es concisas e significativas, facilitando a tomada de decis\u00f5es. <\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Ao dominar as fun\u00e7\u00f5es de agrega\u00e7\u00e3o e combin\u00e1-las com outras cl\u00e1usulas SQL, voc\u00ea poder\u00e1 realizar an\u00e1lises de dados mais complexas e obter insights valiosos sobre seus neg\u00f3cios.<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Toda jornada tem um in\u00edcio, e o in\u00edcio para se tornar um desenvolvedor back-end \u00e9 dominar as seguintes tecnologias, que voc\u00ea encontra aqui mesmo:<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><a href=\"\/category\/sql\"><img loading=\"lazy\" decoding=\"async\" width=\"758\" height=\"426\" src=\"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/05\/Capa-Artigos-2.webp\" alt=\"SQL\" class=\"wp-image-942\" srcset=\"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/05\/Capa-Artigos-2.webp 758w, https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/05\/Capa-Artigos-2-300x169.webp 300w\" sizes=\"auto, (max-width: 758px) 100vw, 758px\" \/><\/a><figcaption class=\"wp-element-caption\">SQL<\/figcaption><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><a href=\"\/category\/php\"><img loading=\"lazy\" decoding=\"async\" width=\"758\" height=\"426\" src=\"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/11\/Capa-PHP.png\" alt=\"Capa Curso PHP\" class=\"wp-image-2835\" srcset=\"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/11\/Capa-PHP.png 758w, https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/11\/Capa-PHP-300x169.png 300w\" sizes=\"auto, (max-width: 758px) 100vw, 758px\" \/><\/a><figcaption class=\"wp-element-caption\">PHP<\/figcaption><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><a href=\"\/category\/laravel\"><img loading=\"lazy\" decoding=\"async\" width=\"758\" height=\"426\" src=\"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/11\/Laravel.webp\" alt=\"Laravel\" class=\"wp-image-1642\" srcset=\"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/11\/Laravel.webp 758w, https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/11\/Laravel-300x169.webp 300w\" sizes=\"auto, (max-width: 758px) 100vw, 758px\" \/><\/a><figcaption class=\"wp-element-caption\">Laravel<\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">E se voc\u00ea gosta do nosso conte\u00fado, n\u00e3o deixe de contribuir adquirindo os servi\u00e7os e produtos dos nossos apoiadores e empresas que somos associados:<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/hostinger.com.br\/?REFERRALCODE=1THIAGO62\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"250\" src=\"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/03\/hostinger.png\" alt=\"Hospedagem Hostinger\" class=\"wp-image-92\"\/><\/a><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/amzn.to\/3SNDYlc\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"250\" src=\"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/08\/ofertas-amazon.webp\" alt=\"Ofertas Amazon\" class=\"wp-image-1308\"\/><\/a><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/amzn.to\/3SNKmt0\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"250\" src=\"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/08\/amazonprime.webp\" alt=\"Amazon Prime\" class=\"wp-image-1307\"\/><\/a><\/figure>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p><span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Tempo de leitura: <\/span> <span class=\"rt-time\"> 3<\/span> <span class=\"rt-label rt-postfix\">minutos<\/span><\/span>Agregando Dados no SQL: Quando trabalhamos com grandes volumes de dados em bancos de dados&#8230;<\/p>\n","protected":false},"author":1,"featured_media":942,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-986","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","wpcat-10-id"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Agregando Dados no SQL - BLOG THIAGO ROSSI<\/title>\n<meta name=\"description\" content=\"Agregando Dados no SQL: Neste artigo, vamos explorar as principais fun\u00e7\u00f5es de agrega\u00e7\u00e3o do SQL e como utiliz\u00e1-las para obter insights ...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/thiagorossi.com.br\/blog\/agregando-dados-no-sql\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Agregando Dados no SQL - BLOG THIAGO ROSSI\" \/>\n<meta property=\"og:description\" content=\"Agregando Dados no SQL: Neste artigo, vamos explorar as principais fun\u00e7\u00f5es de agrega\u00e7\u00e3o do SQL e como utiliz\u00e1-las para obter insights ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/thiagorossi.com.br\/blog\/agregando-dados-no-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"BLOG THIAGO ROSSI\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-14T23:50:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-04T18:05:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/05\/Capa-Artigos-2.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"758\" \/>\n\t<meta property=\"og:image:height\" content=\"426\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Thiago Rossi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Thiago Rossi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/agregando-dados-no-sql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/agregando-dados-no-sql\\\/\"},\"author\":{\"name\":\"Thiago Rossi\",\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/#\\\/schema\\\/person\\\/5f28286948ec2afdeb2e044a2196cd87\"},\"headline\":\"Agregando Dados no SQL\",\"datePublished\":\"2024-05-14T23:50:56+00:00\",\"dateModified\":\"2024-12-04T18:05:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/agregando-dados-no-sql\\\/\"},\"wordCount\":648,\"publisher\":{\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/agregando-dados-no-sql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/Capa-Artigos-2.webp\",\"articleSection\":[\"SQL\"],\"inLanguage\":\"pt-BR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/agregando-dados-no-sql\\\/\",\"url\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/agregando-dados-no-sql\\\/\",\"name\":\"Agregando Dados no SQL - BLOG THIAGO ROSSI\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/agregando-dados-no-sql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/agregando-dados-no-sql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/Capa-Artigos-2.webp\",\"datePublished\":\"2024-05-14T23:50:56+00:00\",\"dateModified\":\"2024-12-04T18:05:06+00:00\",\"description\":\"Agregando Dados no SQL: Neste artigo, vamos explorar as principais fun\u00e7\u00f5es de agrega\u00e7\u00e3o do SQL e como utiliz\u00e1-las para obter insights ...\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/agregando-dados-no-sql\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/agregando-dados-no-sql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/agregando-dados-no-sql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/Capa-Artigos-2.webp\",\"contentUrl\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/Capa-Artigos-2.webp\",\"width\":758,\"height\":426,\"caption\":\"SQL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/agregando-dados-no-sql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Agregando Dados no SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/\",\"name\":\"THIAGO ROSSI\",\"description\":\"Mais de 20 anos de experi\u00eancia no mercado de TI!\",\"publisher\":{\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/#organization\"},\"alternateName\":\"TR | CURSO WEB DEV\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/#organization\",\"name\":\"THIAGO ROSSI\",\"alternateName\":\"TR | CURSO WEB DEV\",\"url\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/new-logo.webp\",\"contentUrl\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/new-logo.webp\",\"width\":300,\"height\":300,\"caption\":\"THIAGO ROSSI\"},\"image\":{\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/linkedin.com\\\/in\\\/thiagox86\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/#\\\/schema\\\/person\\\/5f28286948ec2afdeb2e044a2196cd87\",\"name\":\"Thiago Rossi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bb28b4665f4162bab9fbef8db5a7f00597f79ab90ece9a67189bb6bce78d5786?s=96&d=retro&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bb28b4665f4162bab9fbef8db5a7f00597f79ab90ece9a67189bb6bce78d5786?s=96&d=retro&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bb28b4665f4162bab9fbef8db5a7f00597f79ab90ece9a67189bb6bce78d5786?s=96&d=retro&r=g\",\"caption\":\"Thiago Rossi\"},\"description\":\"Com mais de 20 anos de jornada na tecnologia, minha trajet\u00f3ria evoluiu do ensino t\u00e9cnico \u00e0 arquitetura de sistemas complexos. Hoje, foco minha expertise no desenvolvimento de solu\u00e7\u00f5es de Intelig\u00eancia Artificial nativa e an\u00e1lise de dados p\u00fablicos, utilizando o ecossistema PHP para transformar dados brutos em transpar\u00eancia e efici\u00eancia. Como autor e desenvolvedor, acredito na democratiza\u00e7\u00e3o do conhecimento. Essa vis\u00e3o resultou em uma biblioteca de mais de 530 artigos gratuitos, cobrindo desde a base do WebDev e Infraestrutura at\u00e9 os bastidores da ind\u00fastria de Jogos e IA. No universo de Game Design, sou autor do livro \\\"GDD \u2013 O Guia Definitivo\\\" e documento ativamente meus processos atrav\u00e9s de DevLogs, unindo rigor t\u00e9cnico e criatividade em projetos desenvolvidos com GDevelop 5. Meu compromisso \u00e9 conectar engenharia de ponta com as reais oportunidades do mercado de tecnologia.\",\"sameAs\":[\"https:\\\/\\\/thiagorossi.com.br\\\/blog\",\"https:\\\/\\\/instagram.com\\\/thiagorossix86\",\"https:\\\/\\\/linkedin.com\\\/in\\\/thiagox86\"],\"url\":\"https:\\\/\\\/thiagorossi.com.br\\\/blog\\\/author\\\/thiagorossi\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Agregando Dados no SQL - BLOG THIAGO ROSSI","description":"Agregando Dados no SQL: Neste artigo, vamos explorar as principais fun\u00e7\u00f5es de agrega\u00e7\u00e3o do SQL e como utiliz\u00e1-las para obter insights ...","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:\/\/thiagorossi.com.br\/blog\/agregando-dados-no-sql\/","og_locale":"pt_BR","og_type":"article","og_title":"Agregando Dados no SQL - BLOG THIAGO ROSSI","og_description":"Agregando Dados no SQL: Neste artigo, vamos explorar as principais fun\u00e7\u00f5es de agrega\u00e7\u00e3o do SQL e como utiliz\u00e1-las para obter insights ...","og_url":"https:\/\/thiagorossi.com.br\/blog\/agregando-dados-no-sql\/","og_site_name":"BLOG THIAGO ROSSI","article_published_time":"2024-05-14T23:50:56+00:00","article_modified_time":"2024-12-04T18:05:06+00:00","og_image":[{"width":758,"height":426,"url":"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/05\/Capa-Artigos-2.webp","type":"image\/webp"}],"author":"Thiago Rossi","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Thiago Rossi","Est. tempo de leitura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/thiagorossi.com.br\/blog\/agregando-dados-no-sql\/#article","isPartOf":{"@id":"https:\/\/thiagorossi.com.br\/blog\/agregando-dados-no-sql\/"},"author":{"name":"Thiago Rossi","@id":"https:\/\/thiagorossi.com.br\/blog\/#\/schema\/person\/5f28286948ec2afdeb2e044a2196cd87"},"headline":"Agregando Dados no SQL","datePublished":"2024-05-14T23:50:56+00:00","dateModified":"2024-12-04T18:05:06+00:00","mainEntityOfPage":{"@id":"https:\/\/thiagorossi.com.br\/blog\/agregando-dados-no-sql\/"},"wordCount":648,"publisher":{"@id":"https:\/\/thiagorossi.com.br\/blog\/#organization"},"image":{"@id":"https:\/\/thiagorossi.com.br\/blog\/agregando-dados-no-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/05\/Capa-Artigos-2.webp","articleSection":["SQL"],"inLanguage":"pt-BR"},{"@type":"WebPage","@id":"https:\/\/thiagorossi.com.br\/blog\/agregando-dados-no-sql\/","url":"https:\/\/thiagorossi.com.br\/blog\/agregando-dados-no-sql\/","name":"Agregando Dados no SQL - BLOG THIAGO ROSSI","isPartOf":{"@id":"https:\/\/thiagorossi.com.br\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/thiagorossi.com.br\/blog\/agregando-dados-no-sql\/#primaryimage"},"image":{"@id":"https:\/\/thiagorossi.com.br\/blog\/agregando-dados-no-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/05\/Capa-Artigos-2.webp","datePublished":"2024-05-14T23:50:56+00:00","dateModified":"2024-12-04T18:05:06+00:00","description":"Agregando Dados no SQL: Neste artigo, vamos explorar as principais fun\u00e7\u00f5es de agrega\u00e7\u00e3o do SQL e como utiliz\u00e1-las para obter insights ...","breadcrumb":{"@id":"https:\/\/thiagorossi.com.br\/blog\/agregando-dados-no-sql\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/thiagorossi.com.br\/blog\/agregando-dados-no-sql\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/thiagorossi.com.br\/blog\/agregando-dados-no-sql\/#primaryimage","url":"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/05\/Capa-Artigos-2.webp","contentUrl":"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/05\/Capa-Artigos-2.webp","width":758,"height":426,"caption":"SQL"},{"@type":"BreadcrumbList","@id":"https:\/\/thiagorossi.com.br\/blog\/agregando-dados-no-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/thiagorossi.com.br\/blog\/"},{"@type":"ListItem","position":2,"name":"Agregando Dados no SQL"}]},{"@type":"WebSite","@id":"https:\/\/thiagorossi.com.br\/blog\/#website","url":"https:\/\/thiagorossi.com.br\/blog\/","name":"THIAGO ROSSI","description":"Mais de 20 anos de experi\u00eancia no mercado de TI!","publisher":{"@id":"https:\/\/thiagorossi.com.br\/blog\/#organization"},"alternateName":"TR | CURSO WEB DEV","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/thiagorossi.com.br\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":"Organization","@id":"https:\/\/thiagorossi.com.br\/blog\/#organization","name":"THIAGO ROSSI","alternateName":"TR | CURSO WEB DEV","url":"https:\/\/thiagorossi.com.br\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/thiagorossi.com.br\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/04\/new-logo.webp","contentUrl":"https:\/\/thiagorossi.com.br\/blog\/wp-content\/uploads\/2024\/04\/new-logo.webp","width":300,"height":300,"caption":"THIAGO ROSSI"},"image":{"@id":"https:\/\/thiagorossi.com.br\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/linkedin.com\/in\/thiagox86"]},{"@type":"Person","@id":"https:\/\/thiagorossi.com.br\/blog\/#\/schema\/person\/5f28286948ec2afdeb2e044a2196cd87","name":"Thiago Rossi","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/secure.gravatar.com\/avatar\/bb28b4665f4162bab9fbef8db5a7f00597f79ab90ece9a67189bb6bce78d5786?s=96&d=retro&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/bb28b4665f4162bab9fbef8db5a7f00597f79ab90ece9a67189bb6bce78d5786?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bb28b4665f4162bab9fbef8db5a7f00597f79ab90ece9a67189bb6bce78d5786?s=96&d=retro&r=g","caption":"Thiago Rossi"},"description":"Com mais de 20 anos de jornada na tecnologia, minha trajet\u00f3ria evoluiu do ensino t\u00e9cnico \u00e0 arquitetura de sistemas complexos. Hoje, foco minha expertise no desenvolvimento de solu\u00e7\u00f5es de Intelig\u00eancia Artificial nativa e an\u00e1lise de dados p\u00fablicos, utilizando o ecossistema PHP para transformar dados brutos em transpar\u00eancia e efici\u00eancia. Como autor e desenvolvedor, acredito na democratiza\u00e7\u00e3o do conhecimento. Essa vis\u00e3o resultou em uma biblioteca de mais de 530 artigos gratuitos, cobrindo desde a base do WebDev e Infraestrutura at\u00e9 os bastidores da ind\u00fastria de Jogos e IA. No universo de Game Design, sou autor do livro \"GDD \u2013 O Guia Definitivo\" e documento ativamente meus processos atrav\u00e9s de DevLogs, unindo rigor t\u00e9cnico e criatividade em projetos desenvolvidos com GDevelop 5. Meu compromisso \u00e9 conectar engenharia de ponta com as reais oportunidades do mercado de tecnologia.","sameAs":["https:\/\/thiagorossi.com.br\/blog","https:\/\/instagram.com\/thiagorossix86","https:\/\/linkedin.com\/in\/thiagox86"],"url":"https:\/\/thiagorossi.com.br\/blog\/author\/thiagorossi\/"}]}},"_links":{"self":[{"href":"https:\/\/thiagorossi.com.br\/blog\/wp-json\/wp\/v2\/posts\/986","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thiagorossi.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thiagorossi.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thiagorossi.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thiagorossi.com.br\/blog\/wp-json\/wp\/v2\/comments?post=986"}],"version-history":[{"count":0,"href":"https:\/\/thiagorossi.com.br\/blog\/wp-json\/wp\/v2\/posts\/986\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thiagorossi.com.br\/blog\/wp-json\/wp\/v2\/media\/942"}],"wp:attachment":[{"href":"https:\/\/thiagorossi.com.br\/blog\/wp-json\/wp\/v2\/media?parent=986"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thiagorossi.com.br\/blog\/wp-json\/wp\/v2\/categories?post=986"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thiagorossi.com.br\/blog\/wp-json\/wp\/v2\/tags?post=986"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}