我正在获取date和revenue_rates_usd列，但是当我尝试获取两个日期之间的范围时，我得到的是and错误

Question

pd.read_sql("SELECT * FROM usd_rates;", conn)

   id        date                                  revenue_rates_usd
0  93  2021-07-23  {'AED': 3.673, 'AFN': 79.600004, 'ALL': 103.8,...
1  94  2021-07-24  {'AED': 3.673, 'AFN': 79.600004, 'ALL': 103.8,...

pd.read_sql("SELECT date as date, revenue_rates_usd ->> 'SAR' AS SAR FROM usd_rates;", conn)

         date       sar
0  2021-07-23  3.750918
1  2021-07-24  3.750712

pd.read_sql("SELECT date as date, revenue_rates_usd ->> 'SAR' AS SAR WHERE date BETWEEN '2021-07-23' AND '2021-07-24', FROM usd_rates';", conn)

error =在sql 'SELECT date as date，revenue_rates_usd ->> ' SAR‘WHERE date '2021-07-23’和'2021-07-24'，FROM usd_rates';'：语法错误在或附近"，“第1行：...R WHERE date Error '2021-07-23‘和'2021-07-24'，FROM usd...

Answer 1

在"From“之前有一个逗号(，)，"From”在"Where“之后，可能这就是问题所在。

pd.read_sql("SELECT date AS date，revenue_rates_usd ->> ' SAR‘as SAR FROM usd_rates WHERE date '2021-07-23’AND '2021-07-24';"，conn)