软件测试笔试题-数据库查询题目

如上 图中3张表，写出SQL查询出七年级学生购买会员卡的总金额
方法一：
select sum(v.price * p.count)
from student s join stu_vip p on s.id=p.sutdent_id join vipcard v on p.vipcard_id=v.id
where gread_id=7;
方法二：
select s.grade_id, sum(vip.price*st.count)
from student s,stu_vip st, vipcard vip
where s.id=st.id
and vip.id=st.vipcard_id
and grade_id =7;