[dba-SQLServer] SQL Workout

Billy Pang tuxedo_man at hotmail.com
Wed Nov 16 06:33:35 CST 2005

Arnie, Beth, Dave and Clarice are first names.  Assigning the last name to 
the first names from the very beginning (pretty tough, not possible..errr 
probable) would make the rest a walk in the park.

>From: "Arthur Fuller" <artful at rogers.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: <dba-sqlserver at databaseadvisors.com>
>Subject: Re: [dba-SQLServer] SQL Workout
>Date: Wed, 16 Nov 2005 03:17:51 -0500
>There are problems here, probably subterfuge. The proposition waddles
>between given names and surnames. Perhaps that was intended as part of the
>Given that there are only four people at the table, sub-problem is to 
>the surnames to the proper names and reduce these to (ultimately) four
>people. The sub-sub-problem is that I have no idea whether Nieland or
>Millican or Lehmer is a given name or a surname. In fact, Beth could be a
>surname, as could Clarice and Arnie, though each of these in the
>English-speaking world would most likely be given names.
>There may be a solution, but there are too many assumed propositions (IMO)
>for this to be interesting.
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Billy Pang
>Sent: November 15, 2005 12:18 AM
>To: dba-SQLServer at databaseadvisors.com
>Subject: [dba-SQLServer] SQL Workout
>Hey group:
>I'm always looking for a good sql challenge and I came across a decent one 
>few days ago so I'd thought I'd share.
>The following logical problem (taken from a logical puzzles book) can be
>solved using only SQL.  See if you can solve it using only SQL.  I'll post
>my attempt in a few days.
>Whose round?
>Four friends met for happy hour drinks.  They sat at a round table and over
>the course of the evening had four rounds of drinks.  Each friend paid for 
>different round.  Can you discover where each friend sat, his or her full
>name, and the order in which the four paid for drinks?
>1) the first two people who paid for drinks sat across from each other
>2) Arnie paid for the round just after Millican
>3) Nieland, who didn't pay for the fourth round of drinks, paid for a round
>sometime after Beth did.
>4) The person who sat in seat #2 and the person who bought the fourth round
>of drinks are of the opposite sexes.
>5) Clarice bought a round of drinks sometime after the person who sat in
>seat #1
>6) Kowalski and Lehmer sat across from each other.
>7) Neither Dave nor Kowalski sat in seat #4
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com

More information about the dba-SQLServer mailing list