Skip to content

Instantly share code, notes, and snippets.

@bifacil

bifacil/magia3.sql

Created August 11, 2019 13:04
Show Gist options
  • Save bifacil/39296867c9cd77527518ccb01e599323 to your computer and use it in GitHub Desktop.
Save bifacil/39296867c9cd77527518ccb01e599323 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
magia3.sql
--Ejemplo 3
SELECT
DimGeography.SpanishCountryRegionName AS SpanishCountryRegionName,
sum(sales.OrderQuantity) AS Unidades
FROM DATABASE 'http://bit.ly/2oP72d6'
WHERE DimDate.CalendarYear=2008
GROUP BY DimGeography.SpanishCountryRegionName
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment