Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2010-12-07 : 06:51:46
|
| I just came across a riddle written by Einstein and wondered if any of the bright sparks here could come up with a SQL solution for fun.The Riddle1.In a town, there are five houses, each painted with a different color.2.In every house leaves a person of different nationality.3.Each homeowner drink a different beverage, smokes a different brand of cigar, and owns a different type of pet.The QuestionWho owns the fishes?Hints1.The Brit lives in a red house.2.The Swede keeps dogs as pets.3.The Dane drinks tea.4.The Green house is next to, and on the left of the White house.5.The owner of the Green house drinks coffee.6.The person who smokes Pall Mall rears birds.7.The owner of the Yellow house smokes Dunhill.8.The man living in the center house drinks milk.9.The Norwegian lives in the first house.10.The man who smokes Blends lives next to the one who keeps cats.11.The man who keeps horses lives next to the man who smokes Dunhill.12.The man who smokes Blue Master drinks beer.13.The German smokes Prince.14.The Norwegian lives next to the blue house.15.The man who smokes Blends has a neighbor who drinks watersteve-----------I used to think I wasn't a morning person but it never got better in the afternoon |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2010-12-07 : 10:26:07
|
| Oops, though to be fair that was a year before I discovered SQLTeam-----------I used to think I wasn't a morning person but it never got better in the afternoon |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-12-07 : 10:48:18
|
| Not a problem, it's a good puzzle. Did you try any solutions yourself? Don't read the results until you've tried it. |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2010-12-08 : 04:47:38
|
| I'm intending to have a bash at it soon-----------I used to think I wasn't a morning person but it never got better in the afternoon |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2010-12-12 : 13:35:36
|
| "Fish-finder General" just doesn't have the right ring! |
|
|
|
|
|
|
The Riddler