Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Fun Challenge #2
Brian Peasland wrote:
> Daniel Morgan wrote:
>
>>Two mathematicians (Boris and Vladimir) met accidently for the first >>time in 20 years. >> >>They greet each other and begin catching up on their respective lives. >> >>Boris asks Vladi >>"Do you have any children?" "Yes" replies Vladimir, "I have three." "How >>old are they?", asks Boris. >> >>"The product of their ages is 36 and the sum of their ages is equal to >>the number of windows on that building across the street." Boris looks >>at the building, counts the windows then says "Vladi, that still doesn't >>tell me the ages." "Ah, says Vladi, then I must tell you that the eldest >>has red hair." "Oh", says Boris, "now I know their ages." What are the >>ages of Boris' children? >> >>Create a table, load it with data, and write a single SQL statement to >>produce the data set required to deduce the answer ... then deduce away! >> >>-- >>Daniel Morgan >>http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp >>http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp >>damorgan_at_x.washington.edu >>(replace 'x' with a 'u' to reply)
Actually the second clue is essential to solving the problem. But lets give everyone a shot at it before disclosing the correct result.
Remember this is a SQL challenge ... just looking up the answer in a book or working it out on paper doesn't count. Your insert statements would not have gotten you a passing grade in class last night in that you manually produced the possible ages for your insert statement by hand.
BTW: One of your possible answer is excluded given the wording of the puzzle. A correct solution would have avoided it. ;-)
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Wed Mar 03 2004 - 19:54:53 CST