Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHi 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?