Skip to content

v1.0
Compare
Choose a tag to compare
@JustinFrizzell JustinFrizzell released this 11 Oct 21:57
· 7 commits to main since this release
v1.0
eb708cd

Initial release.

Contains the WideWorldImporters database project including three new views and a user defined function:

  • Challenges.MonthlySalesSummary View of monthly sales figures split by city
  • Challenges.TopSellingProductsByCity View of top 5 selling products split for each city
  • Challenges.StockItemSalesDistribution View showing the cumulative distribution of revenue by product
  • Challenges.ufn_GetTotalOrderWeight Function returning the total weight of a given OrderID
Assets 3
Loading