I have two tables, first the table Tickets:
ticketid | gameid
---------+-----------
1 | 6938
2 | 6939
3 | 6940
Second the table Tickets_nums
ticketid | num
---------+-------
1 | 8
1 | 13
1 | 27
1 | 34
1 | 29
1 | 45
1 | 68
2 | 3
2 | 11
2 | 18
2 | 21
2 | 27
2 | 46
2 | 56
2 | 70
3 | 2
3 | 34
3 | 44
3 | 49
3 | 51
3 | 56
3 | 68
Now i need query to show me (most popular 5 numbers, most least 10 numbers - “Rare Numbers”) from last 50 games (games its by gameid).
But the most least 10 numbers (Rare Numbers) needed check not only from db rows + from total numbers (1 - 70)
And in the end, needed show like this
most popular 5 numbers
----------------------
14 (178 times)
26 (160 times)
39 (151 times)
44 (143 times)
69 (139 times)
most least 10 numbers
----------------------
15 (0 times)
19 (0 times)
21 (6 times)
30 (12 times)
34 (17 times)
38 (29 times)
41 (34 times)
42 (46 times)
52 (51 times)
67 (64 times)
Thank you for help!