Python & Sqlite3 -子集一个表，然后连接另外两个表

SELECT * FROM A WHERE condition;

SELECT * FROM A JOIN B ON condition;

import sqlite3

conn = sqlite3.connect('database.db')

conn.execute('''CREATE TABLE A
                (id INT PRIMARY KEY     NOT NULL,
                name           TEXT    NOT NULL,
                age            INT     NOT NULL);''')

conn.execute('''CREATE TABLE B
                (id INT PRIMARY KEY     NOT NULL,
                address        TEXT    NOT NULL,
                phone          TEXT    NOT NULL);''')

conn.execute('''CREATE TABLE C
                (id INT PRIMARY KEY     NOT NULL,
                salary         REAL    NOT NULL);''')

conn.execute("INSERT INTO A (id, name, age) VALUES (1, 'John', 25)")
conn.execute("INSERT INTO A (id, name, age) VALUES (2, 'Alice', 30)")
conn.execute("INSERT INTO B (id, address, phone) VALUES (1, '123 Main St', '123-456-7890')")
conn.execute("INSERT INTO B (id, address, phone) VALUES (2, '456 Elm St', '987-654-3210')")
conn.execute("INSERT INTO C (id, salary) VALUES (1, 5000)")
conn.execute("INSERT INTO C (id, salary) VALUES (2, 6000)")

cursor = conn.execute("SELECT * FROM A WHERE age > 25")
subset_table = cursor.fetchall()

cursor = conn.execute("SELECT * FROM A JOIN B ON A.id = B.id JOIN C ON A.id = C.id")
joined_table = cursor.fetchall()