In python 3.6.

def find_all_years (db): list-year= [] for key in db for item in db [key]: if not item[0] in list_year: list year.append (item [0]) return sorted (list_year) def total_count_for_name (db, name, gender): count = 0 if (name, gender) in db: List-name = db[ (name, gender)] for item in list_name: count = count item [1] return count def names_by_year (db, year) result-db {} = for item in db: content = (0, 0, 0) for list_name in db[item]: if ist-name [0] year: content - list name break if content [0] != 0; if item in result db: (year, count, rank) = result-db [item] [0] result, dblitem] = [(year, count + content [1], rank)] else: result_db [item][(year, content [1], content [2])] return result db