Másik sql és python

import sqlite3



DB_NAME = "skandinav_lotto.db"





def load_draws():

    conn = sqlite3.connect(DB_NAME)

    cur = conn.cursor()



    cur.execute("""

        SELECT numbers

        FROM draws

        ORDER BY id ASC

    """)



    rows = cur.fetchall()

    conn.close()



    return [list(map(int, r[0].split(","))) for r in rows]





def coldest_7(draws):

    last_index = {}



    for idx, numbers in enumerate(draws):

        for n in numbers:

            last_index[n] = idx



    sorted_cold = sorted(last_index.items(), key=lambda x: x[1])



    return sorted_cold[:7]





def main():

    draws = load_draws()



    if not draws:

        print("Nincs adat")

        return



    result = coldest_7(draws)



    print("❄️ LEGHIDEGEBB 7 SZÁM:\n")



    for num, idx in result:

        print(f"{num} -> utoljára a {idx}. sorsolásban volt")





if __name__ == "__main__":

    main()