Challenge #471: Find the Best Job Offer

[Qiu]

Fun one.

Spoiler

had to refer others to figure out to use 52 weeks/year.

[ycai]

My solution:

Spoiler

[SteveY02]

Done. 

But I have to say, Round function is completely different from SQL or Tableau, which is so weird.

[Hub119]

Technically this should be done with drive distance and not straight line distance, but given that most people don't have the TomTom data licensed I went ahead and solved this using straight line distance to match up with the given solution.

Spoiler

[Diwan]

The output column is ordered as per requirements

[griffinwelsh]

Thanks for featuring my submission!

[Zach_Thomason]

Had alot of fun with this one 

[mattnason1]

This one was fun.  Did a bit extra and added a pay/hour to the output since I think it was intended based on the dataset.

[jfissel]

Spoiler

[Carolyn]

Solved! I don't agree with the assumption that all Days Off per year will be against in office days (e.g. if there are 20 days off per year, that means 20 fewer days in the office... maybe you're WFH on Fridays and all the Days Off are on Friday)... however, if you're being smart about it, I guess it's plausible :)

Spoiler