import platform
import sqlite3

print(f"Python {platform.python_version()}")
print(f"SQLite {sqlite3.sqlite_version}")

with sqlite3.connect(":memory:") as connection:
    connection.execute(
        "CREATE TABLE students (student_id TEXT NOT NULL PRIMARY KEY, name TEXT NOT NULL)"
    )
    connection.executemany(
        "INSERT INTO students (student_id, name) VALUES (?, ?)",
        [("S01", "サリタ"), ("S02", "ラジャン")],
    )
    rows = connection.execute(
        "SELECT student_id, name FROM students ORDER BY student_id"
    ).fetchall()

print("student_id | name")
for student_id, name in rows:
    print(f"{student_id} | {name}")
