Skip to content

Instantly share code, notes, and snippets.

@bifacil

bifacil/magia5.sql

Created August 11, 2019 13:06
Show Gist options
  • Save bifacil/56e4010719b1f12a3dcdd6861068ca85 to your computer and use it in GitHub Desktop.
Save bifacil/56e4010719b1f12a3dcdd6861068ca85 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
magia5.sql
-- Ejemplo 5
SELECT
DimDate.CalendarYear AS CalendarYear,
sum(isales.SalesAmount) AS ventasInternet,
sum(sales.SalesAmount) AS ventasReseller,
ventasInternet+ventasReseller VentasTotales
FROM DATABASE 'http://bit.ly/2oP72d6'
WHERE DimGeography.SpanishCountryRegionName='Francia'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment