import sqlite3
myconnection = sqlite3.connect("movie.db")
mycursor = myconnection.cursor()

favGenre = input("Enter your favourite Genre of film: ")
favYear = int(input("Enter the year of the film: "))

mycursor.execute("""
    SELECT film.title, genre.genreName, film.releaseYear
        FROM film
        INNER JOIN filmgenre ON film.filmID = filmgenre.filmID
        INNER JOIN genre ON filmgenre.genreID = genre.genreID
        WHERE genre.genreName = ? AND film.releaseYear = ?""",
        (favGenre,favYear))

i=0
singleJoinRecord = mycursor.fetchone()
while singleJoinRecord:
    print("Film ",i,"   ",singleJoinRecord)
    i+=1
    singleJoinRecord=mycursor.fetchone()