无法解析Function query参数2:NO_COLUMN: a的查询字符串

Question

我试图得到一个随机的膳食计划设置，我卡住了这个错误信息，"无法解析查询字符串的函数查询参数2:NO_COLUMN: a ";在这段代码

=QUERY({Curries!A2:D;Soups!A2:D;Pasta!A2:D;Casseroles!A2:D},"Select A,C where C <= "& C4 &" Order by D desc Limit 5")

如有任何建议，不胜感激。

Answer 1

useColreferences:

=QUERY({Curries!A2:D; Soups!A2:D; Pasta!A2:D; Casseroles!A2:D},
"select Col1,Col3 where Col3 <= "&C4&" order by Col4 desc limit 5")