Длинные комедии

import sqlite3
db_name = input()
conor = sqlite3.connect(db_name)
nor = conor.cursor()
result = nor.execute("""SELECT title FROM Films WHERE duration => 60 
            (genre=(
SELECT id FROM genres
            WHERE title = 'комедия'))""").fetchall()
for elem in result:
    print(elem[0])
conor.close()

import sqlite3
db_name = input()
conor = sqlite3.connect(db_name)
nor = conor.cursor()
result = nor.execute('''SELECT title FROM Films 
            WHERE duration >= 60 genre=(
        SELECT id FROM genres
            WHERE title = 'комедия')''').fetchall()
for elem in result:
    print(elem[0])
conor.close()

import sqlite3
db_name = input()
conor = sqlite3.connect(db_name)
nor = conor.cursor()
result = nor.execute('''SELECT title FROM Films 
            WHERE duration >= 60 AND genre=(
        SELECT id FROM genres
            WHERE title = 'комедия')''').fetchall()
for elem in result:
    print(elem[0])
conor.close()

import sqlite3
 
dbname = input().strip()
con = sqlite3.connect(dbname)
cur = con.cursor()
query = '''
select films.title
from films
left join genres on genres.id = films.genre
where films.duration >= 60 and genres.title = 'комедия'
'''
result = cur.execute(query).fetchall()
for row in result:
    print(row[0])
 
con.close()