⚠️ 一格塞一串:加一门课就多算一个
把选课写成一格 "数学,英语",用模糊匹配数"选了数学的有几人"。然后再加一位学生选了高等数学,同样再数一次。输出两次的结果(用 / 隔开)。
import sqlite3
db = sqlite3.connect(":memory:")
db.execute("CREATE TABLE bad1nf (student TEXT, courses TEXT)")
db.executemany("INSERT INTO bad1nf VALUES (?,?)", [
("阿岚", "数学,英语"), ("小满", "数学,物理"),
("阿泰", "英语"), ("南风", "数学")])
a = db.execute("SELECT COUNT(*) FROM bad1nf "
"WHERE courses LIKE '%数学%'").fetchone()[0]
db.execute("INSERT INTO bad1nf VALUES ('北辰', '高等数学')")
b = db.execute("SELECT COUNT(*) FROM bad1nf "
"WHERE courses LIKE '%数学%'").fetchone()[0]
print(str(a) + "/" + str(b))
全部评论