1) select distinct(posdept) from administrator.nm_item
2) select count(distinct posdept) from administrator.nm_item(ans=27)
3) select house,retail-selltrl from administrator.nm_house
4)select count(distinct mvmtnum) from administrator.nm_item(ans=280543)