import sqlite3

setup_statements = [
    """CREATE TABLE exam (
        sub_code TEXT,
        test INT,
        marks INT,
        roll_no INT
    )""",
    """CREATE TABLE subject (
        name TEXT,
        sub_code TEXT
    )""",
    """INSERT INTO exam VALUES ('SCI', 0, 89, 0)""",
    """INSERT INTO exam VALUES ('HIST', 0, 100, 0)""",
    """INSERT INTO exam VALUES ('MATH', 0, 70, 1)""",
    """INSERT INTO subject VALUES('Science', 'SCI')""",
    """INSERT INTO subject VALUES('History', 'HIST')""",
    """INSERT INTO subject VALUES('Mathematics', 'MATH')""",
]
marks_query = """
    SELECT
        exam.test Test,
        subject.name Subject,
        exam.sub_code 'Subject Code',
        exam.marks Marks
    FROM exam
    INNER JOIN subject ON exam.sub_code = subject.sub_code
    WHERE roll_no=?
    ORDER BY exam.test,exam.sub_code;
    """

with sqlite3.connect(":memory:") as con:
    cur = con.cursor()
    for s in setup_statements:
        cur.execute(s)

    con.commit()
    cur.execute(marks_query, ("0",))
    for row in cur.fetchall():
        print(row)