Looking for one number for SQL query. See example below:Prev TopicNext Topic

• SQL-MAN

  

  Milwaukee, Wisconsin
  United States
  Member #157,444
  July 19, 2014
  1,101 Posts
  Offline
  Sep 7, 2014, 11:40 pm

  ▲▼

  Can anyone predict one key number for the 9/8/14 Pick 3 drawing?

  Example:

  Let's say that you have a very strong hunch that one of the numbers for tomorrow's Pick 3 drawing is 4.

  If the number 4 is in a combination whose sum is not equal to the last eight sums, then one of the following combinations will occur:

  kEY = 4 FROM ALL COMBINATIONS  AND SUM <> LAST 8 SUMS
  x	y	z	SUM	COMBO
  4	9	9	22	499
  4	8	9	21	489
  4	8	8	20	488
  4	7	9	20	479
  4	7	8	19	478
  4	6	9	19	469
  4	7	7	18	477
  4	6	8	18	468
  4	5	9	18	459
  4	6	6	16	466
  4	5	7	16	457
  4	4	8	16	448
  3	4	9	16	349
  4	4	5	13	445
  3	4	6	13	346
  2	4	7	13	247
  1	4	8	13	148
  0	4	9	13	049
  3	4	4	11	344
  2	4	5	11	245
  1	4	6	11	146
  0	4	7	11	047
  3	3	4	10	334
  2	4	4	10	244
  1	4	5	10	145
  0	4	6	10	046
  1	2	4	7	124
  0	3	4	7	034
  1	1	4	6	114
  0	2	4	6	024
  0	0	4	4	004
  N = 31

  If any of the above combinations have already been selected in 2014, the result would be:

  kEY = 4 FROM ALL COMBINATIONS  AND SUM <> LAST 8 SUMS AND COMBINATION HAS BEEN SELECTED IN 2014
  x	y	z	Sum	COMBO
  4	8	9	21	489
  4	7	8	19	478
  4	5	9	18	459
  4	6	8	18	468
  4	7	7	18	477
  3	4	9	16	349
  4	4	8	16	448
  4	5	7	16	457
  4	6	6	16	466
  0	4	9	13	049
  1	4	8	13	148
  3	4	6	13	346
  0	4	7	11	047
  1	4	6	11	146
  0	4	6	10	046
  1	4	5	10	145
  3	3	4	10	334
  1	2	4	7	124
  0	2	4	6	024
  1	1	4	6	114
  0	0	4	4	004
  N = 21

  I'm new to this forum. If this type of post is inappropriate for the Wisconsin Pick 3 forum, please let me know.

  Thanks
• Igamble

  

  nj
  United States
  Member #145,651
  August 10, 2013
  1,027 Posts
  Offline
  Sep 8, 2014, 12:16 am

  ▲▼
  In response to SQL-MAN

  Quote: Originally posted by SQL-MAN on Sep 7, 2014

  Can anyone predict one key number for the 9/8/14 Pick 3 drawing?

  Example:

  Let's say that you have a very strong hunch that one of the numbers for tomorrow's Pick 3 drawing is 4.

  If the number 4 is in a combination whose sum is not equal to the last eight sums, then one of the following combinations will occur:

  kEY = 4 FROM ALL COMBINATIONS  AND SUM <> LAST 8 SUMS
  x	y	z	SUM	COMBO
  4	9	9	22	499
  4	8	9	21	489
  4	8	8	20	488
  4	7	9	20	479
  4	7	8	19	478
  4	6	9	19	469
  4	7	7	18	477
  4	6	8	18	468
  4	5	9	18	459
  4	6	6	16	466
  4	5	7	16	457
  4	4	8	16	448
  3	4	9	16	349
  4	4	5	13	445
  3	4	6	13	346
  2	4	7	13	247
  1	4	8	13	148
  0	4	9	13	049
  3	4	4	11	344
  2	4	5	11	245
  1	4	6	11	146
  0	4	7	11	047
  3	3	4	10	334
  2	4	4	10	244
  1	4	5	10	145
  0	4	6	10	046
  1	2	4	7	124
  0	3	4	7	034
  1	1	4	6	114
  0	2	4	6	024
  0	0	4	4	004
  N = 31

  If any of the above combinations have already been selected in 2014, the result would be:

  kEY = 4 FROM ALL COMBINATIONS  AND SUM <> LAST 8 SUMS AND COMBINATION HAS BEEN SELECTED IN 2014
  x	y	z	Sum	COMBO
  4	8	9	21	489
  4	7	8	19	478
  4	5	9	18	459
  4	6	8	18	468
  4	7	7	18	477
  3	4	9	16	349
  4	4	8	16	448
  4	5	7	16	457
  4	6	6	16	466
  0	4	9	13	049
  1	4	8	13	148
  3	4	6	13	346
  0	4	7	11	047
  1	4	6	11	146
  0	4	6	10	046
  1	4	5	10	145
  3	3	4	10	334
  1	2	4	7	124
  0	2	4	6	024
  1	1	4	6	114
  0	0	4	4	004
  N = 21

  I'm new to this forum. If this type of post is inappropriate for the Wisconsin Pick 3 forum, please let me know.

  Thanks

  WELCOME TO LP SQL MAN !is your  only 3rd post and you look like a winner already…great work !

  IT WOULD LOOK BETTER IF IS POSTED IN LOTTERY SYSTEMS FORUM -IT GETS MORE VIEWS OR IN THE MATHEMATICS FORUM.SORRY FOR SPELLING ERRORS..OK ENJOY 

  ps-i may need you to program something in the future …i will send pm