1.查询孙杨在中国银行的存款信息
2.查询存款日期在2004年之后的农业银行的存款信息,并按降序排列
这两个怎么写?我一直写错,这是为什么?详解必采纳
为什么这里显示我bank_name这里错误?select d_id,b_id,c_id,dep_date,dep_type amount from deposite where dep_date=(select dep_date from deposite where dep_date>='2004') and bank_name=(select deposite.d_id=bank.b_id where bank_name="农业银行") order by date desc;
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 'where bank_name="农业银行") order by date desc' at line 1