#013 Filter by clustered value in Azure SQL

This T-SQL code performs a query on the "f.Moeda_Cotacoes" table. I'll explain each part

1. CURRENCY, AVG(TAXA_VENDA)

   :
   • SELECT: Indicates that the next part of the code will specify which columns will be returned in the query.
   • CURRENCY: This is the column that will be selected.
   • AVG(TAXA_VENDA): Calculates the average (AVG) of the "TAXA_VENDA" column for each group of records based on the "CURRENCY" column.
FROM

2. f.Moeda_Cotacoes

   :
   • FROM: Indicates the table from which the data will be selected.
   • f.Moeda_Cotacoes: This is the name of the table from which the data will be extracted. The prefix "f." suggests that the table is in a schema called "f".
GROUP BY CURRENCY:

3. GROUP BY:

   • Groups the results based on the specified column, in this case, "CURRENCY". This means that the average will be calculated for each distinct group of values in the "CURRENCY" column.

4. HAVING AVG(TAXA_VENDA) >

   5:
   • HAVING: Filters the group results based on a condition after aggregation, in this case, the condition is that the mean of the "TAXA_VENDA" must be greater than 5.

Therefore, the code returns the average of the sell rates ("TAXA_VENDA") grouped by currency ("CURRENCY"), but only includes the results where the average sell rate is greater than 5. This query is useful when you want to filter aggregated data groups based on a specific condition.