Skip to content

Instantly share code, notes, and snippets.

@bifacil

bifacil/magia2.sql

Created August 11, 2019 13:03
Show Gist options
  • Save bifacil/36fc065b0cd6d28b53db3bc3d2c3156d to your computer and use it in GitHub Desktop.
Save bifacil/36fc065b0cd6d28b53db3bc3d2c3156d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
magia2.sql
--Ejemplo 2
SELECT
DimProduct.EnglishProductName AS EnglishProductName,
sum(sales.OrderQuantity) AS Unidades
FROM DATABASE 'http://bit.ly/2oP72d6'
WHERE
DimGeography.SpanishCountryRegionName='Alemania'
AND DimProductCategory.SpanishProductCategoryName='Bicicleta'
AND DimDate.CalendarYear=2008
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment