Sushi and Summarize()

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '":memory:"."ynabs" where (strftime('%Y-%m-%d', "month") <= cast(? as text) and "' at line 1

select avg(ynabs.income) as "FvnTYOZTDbRgyL9O" from (select * from ":memory:"."ynabs" where (strftime('%Y-%m-%d', "month") <= cast(2023-08-20 as text) and "month" >= 2022-08-20 21:24:22)) as `ynabs`