We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
Hi Please find my solution below.
I then tried to use a merge function to see if I had the same results as the solution. Weirdly enough, when i merged the datasets on the Avg length of stay. I only had a single match? I can't seem to figure out why given that both have the same data types (double) and size(8). Both fields are being rounded to 6 decimal places to for clarity? I'm assuming that this is just a rounding issue between the two output files?