关于#mysql#的问题，请各位专家解答！

这几个怎么做啊 不是很懂 恳请各位专家帮看看，不用程序学 手写就好

img

img

img

不知道表数据字典，对应字段的意思，仅作参考，不保证完全正确

1、select name from country where GDP > 500 and GDP < 100000;
2、SELECT C.Life_Exp FROM Country C ,River R WHERE C.name = R.origin;
3、SELECT Ci.name FROM Country Co , City Ci WHERE Co.name = Ci.country AND ( Co.cont = 'NAM' or Ci.poD < 200 );
4、SELECT Ci.name FROM City CI , City CZ WHERE distant ( CZ.shape , Cl.shape ) < 5000 AND Cl.name = 'Washington D.C.';
5、SELECT Length ( Intersection ( R.shape , CoZ.shape ) As Length FROM River R , Country Col , Country CoZ WHERE Col.Name = 'Argentina' and CoZ.Name = 'Brazil' and R.name = 'Rioparonas' and cross =(R.shape , Col.shape) = 1 ;
6、SELECT touch (Col.shape,CoZ.shape) FROM Country Col , Country CoZ WHERE Col.name = 'Argentina' and CoZ.name = 'Brazil';