Challenge #468: Many-to-Many Like it Hot – Part 1

[SteveY02]

Done.

One question, my original solution did not include values like "1x" in the concat_viscosity column. After checking, I found that the output of the initial file also calculated null values for viscosity. This doesn't seem to make sense. we shouldn't count null value, right?

[dfuhriman]

Spoiler

 

[mattnason1]

Joins took a while to figure out.  But otherwise fun.

[Fizzledrizzle]

I noticed there were nulls on both sides of the solution and tried to account for that as much as possible.

[Woojac]

My solution. I created a union at the end to capture the sauces that did not have a matching Flavor profile. I also noticed that there were a few records with a NULL viscosity. I went ahead and retained these NULLs as these records reflect in the solution. i.e. Sauce ID = 12.

[CeliaC_Silje]

Spoiler

challenge468

Omitted the sorting step as it does not really affecting the result.

[jadepech]

Fun!

[elainebusby]

Fun challenge!

[DeepakPoojary]

Resolved!

[Carlithian]

Well now I really want some chicken wings....

Spoiler