算一次要连几张表

"每门课有几个人选"这个数，规范化之后要连表算。输出两个数：这个查询要扫中间表几行、三门课各几人（连起来）（用 / 隔开）。

enroll_flat（一张宽表，什么都塞在里面）
student  phone  course  teacher  room
阿岚     111    数学    王老师   A101
阿岚     111    英语    李老师   B202
小满     222    数学    王老师   A101
阿泰     333    英语    李老师   B202
小满     222    物理    张老师   C303
南风     444    数学    王老师   A101

拆开之后的三张
student(id, name, phone)          4 行
course (id, name, teacher, room)  3 行
enroll (student_id, course_id)    6 行

import sqlite3
db = sqlite3.connect(":memory:")
db.executescript("""
CREATE TABLE enroll_flat (student TEXT, phone TEXT, course TEXT, teacher TEXT, room TEXT);
CREATE TABLE student (id INTEGER PRIMARY KEY, name TEXT NOT NULL UNIQUE, phone TEXT NOT NULL);
CREATE TABLE course  (id INTEGER PRIMARY KEY, name TEXT NOT NULL UNIQUE,
                      teacher TEXT NOT NULL, room TEXT NOT NULL);
CREATE TABLE enroll  (student_id INTEGER, course_id INTEGER,
                      PRIMARY KEY (student_id, course_id));
""")
db.executemany("INSERT INTO enroll_flat VALUES (?,?,?,?,?)", [
    ("阿岚", "111", "数学", "王老师", "A101"),
    ("阿岚", "111", "英语", "李老师", "B202"),
    ("小满", "222", "数学", "王老师", "A101"),
    ("阿泰", "333", "英语", "李老师", "B202"),
    ("小满", "222", "物理", "张老师", "C303"),
    ("南风", "444", "数学", "王老师", "A101")])
db.executemany("INSERT INTO student VALUES (?,?,?)", [
    (1, "阿岚", "111"), (2, "小满", "222"), (3, "阿泰", "333"), (4, "南风", "444")])
db.executemany("INSERT INTO course VALUES (?,?,?,?)", [
    (1, "数学", "王老师", "A101"), (2, "英语", "李老师", "B202"),
    (3, "物理", "张老师", "C303")])
db.executemany("INSERT INTO enroll VALUES (?,?)", [
    (1, 1), (1, 2), (2, 1), (3, 2), (2, 3), (4, 1)])
n = db.execute("SELECT COUNT(*) FROM enroll").fetchone()[0]
rows = db.execute("SELECT c.name, COUNT(*) FROM enroll e "
                  "JOIN course c ON c.id = e.course_id "
                  "GROUP BY c.id ORDER BY c.id").fetchall()
print(str(n) + "/" + "".join(str(r[1]) for r in rows))