Glueckspilz
Member
This is the way we select the winning numbers:
Select "XXX' Numbers_set from Played_numbers where Province_of_played='XXX' and city_of_played='XXX" and time_of_played='XXX' and Method_of_Played='XXXX'
On each ticket we record the place, the time and the way the numbers have been selected.
We run this query against all played sets. We then feed the drawing machine with the results, the outcome will always be what we want.
For example if we want to have a single winner from Ontario, who played quick pick we run the following query:
Select unique numbers_set from played_numbers where province_of_played='Ontario' and method_of_played='quick pick';
It just takes less than 5 minutes to get the results. We prefer players wo play quick pick because our machine predict the numbers.
If we do not want a winner we run the following query:
Select unique numbers_set from all_numbers_set where numbers_set not in played_numbers;
Select "XXX' Numbers_set from Played_numbers where Province_of_played='XXX' and city_of_played='XXX" and time_of_played='XXX' and Method_of_Played='XXXX'
On each ticket we record the place, the time and the way the numbers have been selected.
We run this query against all played sets. We then feed the drawing machine with the results, the outcome will always be what we want.
For example if we want to have a single winner from Ontario, who played quick pick we run the following query:
Select unique numbers_set from played_numbers where province_of_played='Ontario' and method_of_played='quick pick';
It just takes less than 5 minutes to get the results. We prefer players wo play quick pick because our machine predict the numbers.
If we do not want a winner we run the following query:
Select unique numbers_set from all_numbers_set where numbers_set not in played_numbers;