~_~ python读取数据库错误！！我实在是找不到问题在哪里了

Question

import numpy as np
import pandas as pd
from sqlalchemy import create_engine

mysql_config = {'host': '59.78.102.118',
                'port': 23208,
                'user': 'student',
                'password': 'Python_123456',
                'dbname': 'research'}
mysql_engine = create_engine('mysql+pymysql://student:Python_123456@59.78.102.118:23208/research'.format(**mysql_config), pool_pre_ping=True)

sql = "select Date,Close from stock trading date where Date >= '2005-01-01' AND Date <= '2018-12-31' AND Stkcd = '000041'"
pd_data = pd.read_sql(sql,mysql_engine)
print(pd_data)

Answer 1

select Date,Close from stock trading date where Date >= '2005-01-01' AND Date <= '2018-12-31' AND Stkcd = '000041'
从报错看，应该是这句查询语句错了，然后select Data,Close(这是属性) from stock trading data(这3个单词应该是表吧，你看下表的名称具体是什么，应该不是这么写的，至少应该是有下划线什么的连起来的) where。。。