John C. Kirk (johnckirk) wrote,
John C. Kirk

Logic puzzle

Over at the Microsoft Press blog, they've been promoting Inside Microsoft SQL Server 2008: T-SQL Querying. As well as the blurb about the book itself, they have a logic puzzle:

Two trains race toward each other on a railway segment that’s 100 miles long. The trains are traveling at 100 mph. A mosquito flying at 200 mph flies from one train toward the other, and as soon as it arrives at the other train, it flips its direction and flies back toward the first train. The mosquito continues bouncing back and forth between the trains until the trains crash. What’s the total distance that the mosquito covers until the moment of the crash?

This is taken from the book, which implies that it could be solved by using a SQL query. I'd be more inclined to do something in Excel, i.e. calculating the relative positions of the trains and the mosquito after each minute has passed, then adding up the total distance travelled. Still, either approach is inelegant, and I think I've now found a neater solution.

Basically, I think it's a bit of a trick question. If the trains start out 100 miles apart, and they each travel at 100mph, it will take them 30 minutes to travel 50 miles, then they'll crash. If the mosquito is flying back and forth continuously for that 30 minutes, at 200mph, it will travel 100 miles. We don't need to know the exact positions of the trains each time it "bounces".
Tags: logic

  • RI FED: Asthma

    Each year, the Royal Institution do a set of Christmas lectures: these are presented to a live audience, then broadcast on TV later. They're aimed at…

  • Graph theory

    I've recently been going through my LJ archive and "tagging" my old posts, and that is now basically done. There are some cases where I've introduced…

  • (no subject)

    A few cheerful highlights from the past few days... Tuesday evening was SJA training (as usual), and this week was about deaf awareness/sign…

  • Post a new comment


    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded