Advertisement
Guest User

Untitled

a guest
Oct 14th, 2019
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. import sqlite3
  2.  
  3. con = sqlite3.connect(input())
  4. cur = con.cursor()
  5. result = cur.execute("""
  6. SELECT * FROM Films WHERE year >= 1997
  7. AND genre IN (SELECT id from genres
  8. WHERE title = 'музыка'
  9. OR title = 'анимация')
  10. """).fetchall()
  11. for elem in result:
  12. print(elem[1])
  13. con.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement