Author: Dann Corbit
Date: 14:00:46 06/04/02
Go up one level in this thread
On June 04, 2002 at 16:52:39, Dann Corbit wrote: >On June 04, 2002 at 16:21:23, Rolf Tueschen wrote: >[snip] >>You forgot Mephisto I from 1981, also Monarch! And the Chess System from 1979, >>the one without certain chess features. >> >>But seriously, you can't mean it seriously?! I talked about the chess strength >>in computers at a certain moment. With the same generation, Dan. > >SELECT int([rating]/25), count([Rating]/25) >FROM SSDF >where program_hardware_combo like "*Athlon 1200*" >GROUP BY int([Rating]/25); > >Expr1000 Expr1001 >104 1 >105 2 >106 2 >107 2 >108 4 >109 1 > >SELECT int([rating]/100), count([Rating]/100) >FROM SSDF >where program_hardware_combo like "*K6-2 450*" >GROUP BY int([Rating]/100); > >Expr1000 Expr1001 >24 5 >25 18 >26 8 > >This one's a bit skewed: > >SELECT int([rating]/50), count([Rating]/50) >FROM SSDF >where program_hardware_combo like "* P200 MMX*" >GROUP BY int([Rating]/50); > >Expr1000 Expr1001 >44 1 >45 1 >46 1 >47 5 >48 10 >49 5 Pentium 90 stuff: SELECT int([rating]/50), count([Rating]/50) FROM SSDF WHERE program_hardware_combo like "*Pentium 90*" GROUP BY int([Rating]/50); Expr1000 Expr1001 38 1 42 1 43 1 44 4 45 9 46 11 47 1 Old stuff: SELECT int([rating]/100), count([Rating]/100) FROM SSDF WHERE NOT ( program_hardware_combo like "*Athlon 1200*" OR program_hardware_combo like "*K6-2 450*" OR program_hardware_combo like "* P200 MMX*" OR program_hardware_combo like "*Pentium 90*" ) GROUP BY int([Rating]/100); Expr1000 Expr1001 14 2 15 12 16 12 17 23 18 21 19 21 20 17 21 23 22 8
This page took 0.01 seconds to execute
Last modified: Thu, 15 Apr 21 08:11:13 -0700
Current Computer Chess Club Forums at Talkchess. This site by Sean Mintz.