几个sqlserver语句。

select userid,username,ansnumall,countdate,wtype,case wtype when 2 then 4  when 1 then 3  when 0 then 2  end as jkb from askdb.dbo.parttimelevelinfo where countdate in('2012-9-1','2012-9-2') and ansnumall>=10