SQL語法

select AVG(zip) from ZIP where zip >= 100 and zip <= 300;
select zipid, COUNT(zipid) from address where id <= 10 group by zipid
select * from list join address join zip
where list.addressid = address.id and address.zipid = zip.id
and number like '90%' and status = 'MS';
select * from list join zip where list.addressid = zip.id and number like '%80024400%'