import sqlite3
with sqlite3.connect(':memory:') as connection:
    connection.execute('CREATE TABLE books (id INTEGER PRIMARY KEY, title TEXT NOT NULL, author TEXT NOT NULL)')
    books = [('Algorithms Made Clear', 'A. Writer'), ('Learning Python', 'B. Author')]
    connection.executemany('INSERT INTO books(title, author) VALUES (?, ?)', books)
    rows = connection.execute('SELECT title FROM books ORDER BY title').fetchall()
    assert rows == [('Algorithms Made Clear',), ('Learning Python',)]
    print(rows)