Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import sqlite3
- con = sqlite3.connect(input())
- cur = con.cursor()
- result = cur.execute("""
- SELECT * FROM Films WHERE year >= 1997
- AND genre IN (SELECT id from genres
- WHERE title = 'музыка'
- OR title = 'анимация')
- """).fetchall()
- for elem in result:
- print(elem[1])
- con.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement