sqlwhenthen用法 case when then else用法

SQL中CASE WHEN THEN的用法？select a，count(*) from (select a=case when agewhen age>=30 a...