Challenge #198: Beverage Inventory

[AYXAcademy]

A solution to last week's challenge can be found here! 

This week's challenge comes to us from @bdelarosa - thank you for your contribution! 

Using the provided input files, organize the data to display:

- Inventory levels for products by location
- Previous sales history per product per location
- Average sales per product per location
- Total incoming product per product per location
- Earliest Purchase Order date a product may arrive.

Display all inventory levels even if no sales exist or no products are on purchase order.

 Source: GIPHY

[Aaron_Harter]

This challenge is making me thirsty!

Spoiler

[OllieClarke]

Here's my effort:

Spoiler

[JoshuaGostick]

There was some frustration trying to identify which table some of the fields were coming from but other than that a good fun challenge!

Spoiler

[Blake]

Shout out to the RGV locations in this challenge! 

Spoiler

[NicoleJohnson]

My solution!

Spoiler

 

Cheers!!

NJ

[nivi_s]

Solved!

Now I just gotta get some pop-tarts to go with these beers!

Spoiler

Might be a more elegant way to do this - the unmatched fields were a bit of a pain, but I think I worked it out in the end! 

[ponraj]

Here is my solution. 

Spoiler

[RolandSchubert]

My solution. Cheers.

Spoiler

[JORGE4900]

I found the most time-consuming thing was to add default missing values in a manual way such as Location, Inventory Qty, Units Sold, or dates; other than that, it was pretty straight forward doing a couple of joins to get solution.

Happy Monday!

Spoiler