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