sql 语句

以下三张表

  student（id,sex, gender, age）

  subject(sid,name)

  score(id sid score)

select a.id,score from a,b where a.id=b.id and age>18

update socre set score='score+10' where id in(select id from age>18)

delete from socroe WHERE `id` IN (SELECT `id` FROM sutudent WHERE `age` > 18) AND `cid` IN (SELECT `cid` FROM `score` WHERE `name`='x')