RE: SQ puzzle

2004-03-08 Thread Mike Brando
> > Of course the problem cannot be solved with M$ SQLServer :-) And why pray tell is that? I suppose if Vladimir and wife were very prolific then (4, 3, 3) will also work, which is 10 windows on the building, not 13 (9, 2, 2) I also happen to be one of those who have two children about 11 mon

Re: SQ puzzle

2004-03-08 Thread Sasha Pachev
[EMAIL PROTECTED] wrote: It is interesting to see the various solutions being proposed. Though one item missing is the inclusion of a 1 year old child. It is likely this will be the telling point since it provides one of the possible limiting criteria not mentioned. Most buildings have an ev

Re: SQ puzzle

2004-03-08 Thread beacker
It is interesting to see the various solutions being proposed. Though one item missing is the inclusion of a 1 year old child. It is likely this will be the telling point since it provides one of the possible limiting criteria not mentioned. Most buildings have an even number of windows. So

Re: SQ puzzle

2004-03-08 Thread Sasha Pachev
- It's not very common that the same mother has had two children (not twins) within 12 months. Besides, only during a limited timeframe the ages in years of two such children would be the same. It is possible, and actually is not that uncommon where I live (Utah) - my wife and I have a few friend

Re: SQ puzzle

2004-03-08 Thread Brent Baisley
That depends on your nationality. Two children born in the same year are commonly called Irish twins. But that's even more off topic. On Mar 8, 2004, at 5:59 AM, Jigal van Hemert wrote: - It's not very common that the same mother has had two children (not twins) within 12 months. -- Brent Baisl

Re: SQ puzzle

2004-03-08 Thread Jigal van Hemert
> >- have only one highest age (since there is an "eldest") > >Looking at the output this would only be true for ages 9, 2 and 2 > > Yes but 6,6,1 doesn't necessarily mean that the two children > aged 6 are twins - one could have been born in January and one > in December in the same year and hence

Re: SQ puzzle

2004-03-08 Thread Peter Burden
Jigal van Hemert wrote: Table: CREATE TABLE `age1` ( `age1` tinyint(2) NOT NULL auto_increment, PRIMARY KEY (`age1`) ) TYPE=MyISAM AUTO_INCREMENT=21 ; Data: INSERT INTO `age1` VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20); Q

Re: SQ puzzle

2004-03-08 Thread Jigal van Hemert
Table: CREATE TABLE `age1` ( `age1` tinyint(2) NOT NULL auto_increment, PRIMARY KEY (`age1`) ) TYPE=MyISAM AUTO_INCREMENT=21 ; Data: INSERT INTO `age1` VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20); Query: SELECT * , a.