HAVING e classificação

Os filtros e a ordenação andam de mãos dadas, e com eles podemos interpretar melhor os resultados.

Vamos ver essa mágica em ação escrevendo uma consulta que mostre quais países têm os filmes com maior orçamento médio.

Este exercicio faz parte do curso

SQL Intermediário

Ver curso

Instruções do exercicio

Selecione o country e o orçamento médio como average_budget da tabela films, arredondando para duas casas decimais..
Agrupe os resultados por country.
Filtre os resultados para países com um orçamento médio de mais de um bilhão (1000000000).
Classifique por ordem decrescente de average_budget.

exercicio interativo prático

Tente este exercicio completando este código de exemplo.

-- Select the country and average_budget from films
___
-- Group by country
___
-- Filter to countries with an average_budget of more than one billion
___
-- Order by descending order of the aggregated budget
___

Editar e Executar Código

Este exercicio faz parte do curso

SQL Intermediário

InicianteNível de habilidade

4.9+

35536 reviews

Comece o curso gratuitamente

In this first chapter, you’ll learn how to query a films database and select the data needed to answer questions about the movies and actors. You'll also understand how SQL code is executed and formatted.

Exercise 1: Querying a database Exercise 2: Learning to COUNT()Exercise 3: Practice with COUNT()Exercise 4: SELECT DISTINCT Exercise 5: Query execution Exercise 6: Order of execution Exercise 7: Debugging errors Exercise 8: SQL style Exercise 9: SQL best practices Exercise 10: Formatting Exercise 11: Non-standard fields

Learn about how you can filter numerical and textual data with SQL. Filtering is an important use for this language. You’ll learn how to use new keywords and operators to help you narrow down your query to get results that meet your desired criteria and gain a better understanding of NULL values and how to handle them.

Exercise 1: Filtering numbers Exercise 2: Filtering results Exercise 3: Using WHERE with numbers Exercise 4: Using WHERE with text Exercise 5: Multiple criteria Exercise 6: Using AND Exercise 7: Using OR Exercise 8: Using BETWEEN Exercise 9: Filtering text Exercise 10: LIKE and NOT LIKE Exercise 11: WHERE IN Exercise 12: Combining filtering and selecting Exercise 13: NULL values Exercise 14: What does NULL mean?Exercise 15: Practice with NULLs

SQL allows you to zoom in and out to better understand an entire dataset, its subsets, and its individual records. You'll learn to summarize data using aggregate functions and perform basic arithmetic calculations inside queries to gain insights into what makes a successful film.

Exercise 1: Summarizing data Exercise 2: Aggregate functions and data types Exercise 3: Practice with aggregate functions Exercise 4: Summarizing subsets Exercise 5: Combining aggregate functions with WHERE Exercise 6: Using ROUND()Exercise 7: ROUND() with a negative parameter Exercise 8: Aliasing and arithmetic Exercise 9: Using arithmetic Exercise 10: Aliasing with functions Exercise 11: Rounding results

This final chapter teaches you how to sort and group data. These skills will take your analyses to a new level by helping you uncover critical business insights and identify trends and performance. You'll get hands-on experience to determine which films performed the best and how movie durations and budgets changed over time.

Exercise 1: Ordenação de resultados Exercise 2: Ordenação de texto Exercise 3: Ordenação por campos individuais Exercise 4: Ordenação por vários campos Exercise 5: Agrupamento de dados Exercise 6: GROUP BY com campos individuais Exercise 7: GROUP BY com vários campos Exercise 8: Respostas para perguntas de negócios Exercise 9: Filtragem de dados agrupados Exercise 10: Filtro com HAVING Exercise 11: HAVING e classificação

Exercicio Atual

Exercise 12: Juntando tudo Exercise 13: Parabéns!