在googlecolab中尝试sqlite时，是什么原因导致错误消息“EOF in multiline string”？

Question

我试图在googlecolab中运行以下代码，但收到错误“EOF in multi-line string”

import sqlite3
from google.colab import files
uploaded = files.upload()
#upload file Db-IMDB.db
connection = sqlite3.connect('./Db-IMDB.db')


Yash = pd.read_sql_query("""SELECT da.*
FROM (SELECT pd.pid, pd.name as Director, pa.pid, pa.name as actor, COUNT(*) as cnt,
             RANK() OVER (PARTITION BY pa.pid ORDER BY COUNT(*) DESC) as seqnum,
             COUNT(*) OVER (PARTITION BY pa.pid, COUNT(*)) as num_with_cnt,
      FROM M_director d JOIN
           Person pd
           ON pd.pid = d.pid JOIN
           M_cast c
           ON c.MID = d.MID JOIN
           Person pa
           ON pa.PID = c.PID
      GROUP BY pd.pid, pd.name, pa.pid, pa.name
     ) da
WHERE director = 'Yash Chopra' AND
      seqnum = 1 AND
      num_with_cnt = 1;""",connection)

print(Yash)

我查看了其他用户对这个错误的查询，从我看到的情况来看，它总是由于缺少一个撇号'然而，我检查了我的代码，没有遗漏任何错误。你能帮我找出造成这个错误的原因吗？在

{我的参考资料：^ a1} Getting error when loading CSV file to dataframe using Jupyter notebook

完全错误：

^{pr2}$