Advertisement
Guest User

Untitled

a guest
Oct 19th, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. import sqlite3
  2.  
  3. name = input()
  4. con = sqlite3.connect(name)
  5.  
  6. cur = con.cursor()
  7.  
  8. result = cur.execute("""SELECT title FROM Films
  9. WHERE (genre = (
  10. SELECT id FROM genres
  11. WHERE title = 'музыка') OR
  12. genre = (
  13. SELECT id FROM genres
  14. WHERE title = 'анимация'))
  15. AND
  16. year >= 1997""").fetchall()
  17.  
  18. for elem in result:
  19. print(elem[0])
  20.  
  21. con.close()
  22. ======================
  23. import sqlite3
  24.  
  25. name = input()
  26. con = sqlite3.connect(name)
  27.  
  28. cur = con.cursor()
  29.  
  30. result = cur.execute("""SELECT title FROM Films
  31. WHERE title LIKE '%?'""").fetchall()
  32.  
  33. for elem in result:
  34. print(elem[0])
  35.  
  36. con.close()
  37. =======================
  38. import sqlite3
  39.  
  40. name = input()
  41. con = sqlite3.connect(name)
  42.  
  43. cur = con.cursor()
  44.  
  45. result = cur.execute("""SELECT DISTINCT year FROM Films
  46. WHERE title LIKE 'Ð¥%'""").fetchall()
  47.  
  48. for elem in result:
  49. print(elem[0])
  50.  
  51. con.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement