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.

 All Forums
 Site Related Forums
 The Yak Corral
 The Riddler

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 Riddle

1.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 Question

Who owns the fishes?

Hints

1.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 water

steve

-----------

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 : 09:55:26
We, um, might have stumbled across something like that:

http://www.sqlteam.com/article/reader-challenge-3-find-the-yak

Go to Top of Page

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
Go to Top of Page

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.
Go to Top of Page

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
Go to Top of Page

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2010-12-12 : 13:35:36
"Fish-finder General" just doesn't have the right ring!
Go to Top of Page
   

- Advertisement -