mysql多表查询

select area from areas where cityid=(select cityid from cities where city like '杭州%') and id!=(select min(id) from areas where cityid=(select cityid from cities where city like '杭州%'));

select area from areas where cityid=(select cityid from cities where id=(select min(id) from cities where  provinceid=(select provinceid from provinces where province like '上海%')));