翻译:每一个派生表都应该有一个别名 ! 规范细节
修正:select name ,population,area from (select name,population,area from world where area>3000000 or population >250000000 )t where t.population <250000000 or t.area<3000000;
翻译:每一个派生表都应该有一个别名 ! 规范细节
修正:select name ,population,area from (select name,population,area from world where area>3000000 or population >250000000 )t where t.population <250000000 or t.area<3000000;