Challenge #469: Many-to-Many Like it Hot – Part 2

[SKHENRY]

question in spoiler tags 

Spoiler

sorry to randomly point you out but if i wanted to start i convo i had to pick someone :D

im commenting because i want to be helpful and learn. Doesn’t the  
overall rating have to be the Averaged out before you filter it?,
I thought it was odd when the wording was Average and then noticed multiple sources have different ratings so to meet the requirements we would need to average these ratings otherwise in theory a source that has ratings 1,1,1,5, would get past the filter and be incorrectly reported in the final output 

again sorry to just randomly reply but this is a interesting question and you are lot higher rated then me so I figured I would ask/check as a number of other people also did this and I don’t know if did this right or wrong

from the challange desc

Also include in your output file:

• Manufacturer name and location
• Sauce name
• Heat sources
• Average overall rating
• Percentage of tasters that "loved" the sauce
• Average spiciness
• Flavor notes and viscosity

•  

[fdavy]

Here is my solution

[dfuhriman]

Spoiler

 

[mattnason1]

Quick and simple.

[Zach_Thomason]

Solution. Enjoyed this one. 

[SteveY02]

Done. Simple challenge. However, what confuses me is the usage of the Round function. The parameter settings are different from SQL, Tableau Prep, and all other ETL tools. I really can't understand why it is set this way.

[mennatuallah_ag]

Spoiler

 

 

[MadYX]

I enjoyed this! i kept expecting a 'gotcha' but it was pretty straightforward. one odd note my percentage of tasters is wrong on the classic garlic. looking into what i missed. 

[earth2joy]

Interesting!

[ahsanaali]

Spoiler