import sqlite3

db = sqlite3.connect("test.db")
cur = db.cursor()

cur.execute("CREATE TABLE IF NOT EXISTS movies (title, director, year)")

cur.execute('INSERT INTO movies VALUES ("Jaws", "Spielberg", 1975)')
cur.execute('INSERT INTO movies VALUES ("The Rocky Horror Picture Show", "Sharman", 1975)')

cur.execute('INSERT INTO movies VALUES ("The Exorcist", "Friedkin", 1973)')

cur.execute('INSERT INTO movies VALUES ("The Texas Chainsaw Massacre", "Hooper", 1974)')

cur.execute('INSERT INTO movies VALUES ("Young Frankenstein", "Brooks", 1974)')

cur.execute('INSERT INTO movies VALUES ("One Flew Over the Cuckoo\'s Nest", "Kubrick", 1975)')

results = cur.execute('SELECT * FROM movies')

print("ALL MOVIES ============")
for entry in results:
  print(entry)

print("1975 MOVIES ============")
results = cur.execute('SELECT * FROM movies WHERE year = 1975')
for entry in results:
  print(entry)

print("1975 Speilberg MOVIES ============")
results = cur.execute('SELECT * FROM movies WHERE year = 1975 AND director = "Spielberg"')
for entry in results:
  print(entry)

db.commit()
db.close()