(从[付款]中选择[金额]，其中([payment_account]="确认存款")和([操作]="已收到")和([金额]="95"))

Question

得到一个语法错误无法弄清楚。 请帮忙！感谢

Answer 1

select amount
from payment
where payment_account = 'Confirmation Deposit'
and action = 'Received'
and amount = '95'