我的grails应用程序中有一个Vote域类,其中包含article_id和note等属性SELECTv.article_id, avg(v.note), count(*) FROM vote v where count(*) >= 10 group by v.article_idorder by avg(v.note) desc limit
不过,当我试图通过迁移创建物化视图时,我做了一些小的修改,但以下查询会引发一个错误:SELECTv.voucher_id,v.quantity, COUNT(ov.voucher_id) AS "used", v.quantity - COUNT(ov.voucher_id) AS "remaining"
FROMGROUP BY <em