Using Artificial Intelligence Techniques And SQL To Optimize A Lottery Application


While this could appear a forlorn confidence for making lottery predictions, then let us see whether this may be potential Agen Domino.

The large problem in analyzing lottery results could be that the high quantity of potential combinations. At an ordinary “40 x 6” ball match you can find 3,838,380 lines to pick from.

It is logical to decrease the potential number pool until we employ some AI chances. I’ll utilize the “Prime” probability system that presumes there will probably be two primes, inch strange and 3 even amounts in each winning lineup.

We are going to make an effort to make use of AI to set the prime consequences in some type of blueprint whenever they do occur.

For Instance, the past 6 months outcomes of NZ Lotto were:


The amounts of outcome 2,3,4 and 6 match up with the prime strategy criteria accordingly that we just desire to check at those traces. When we can set a blueprint within the prime consequences subsequently we can substantially lower our mixes to once the prime system amounts show up.

We are going to make use of the Structured Query Language, or SQL, to query with the sequential system database of most potential lottery mixes; an overall total 575,586 traces of 6 amounts.

The arrangement of this database is as follows:


What I’ll do is make a SQL query which chooses each distinct winning sequential system amounts. We may then combine the questions within a “and/or” invoice to pay for the distinct scenarios.

This manner, we are able to study the commonalities between the different outcomes, the same as a real-life AI application.

The majority of the prime consequences above included a minumum of a single number divisible by 4. We could insure that situation for this particular question:


N 4 percent4=0 or 2 N 5 percent4=0 or 2 n-6 percent4=0

Records returned: 525,690

The percentage symbol is really a particular code in SQL that provides us the rest from dividing the 2 amounts.

Each prime lineup seemingly possess atleast 2 amounts within 4 of eachother. We’ll pay that chance such as that:


Records returned: 305,316

We could now combine the questions using the next command:


The joint query came back 276,210 mixes, a decrease of approximately 40%, that is quite striking.

I detected that the very first even number was almost equal to or less than 14 so once I realised which parameter in, the mixes came back were 165,726.

In the future weeks I’ll glance at other common aspects, such as keeping numbers from recent outcomes.


This article explored the prospect of working with AI methods and also SQL to lessen potential mixes. By assessing results that match certain parameters that it will be possible to decrease line amounts and boost our lottery opportunities.

A seasoned SQL, Excel and VBA developer, he’s established a site which produces all probable mixes of lottery amounts and also invites suggestions concerning its own development.

No comments yet

leave a comment