[sqlite] nested functions in select

[Doug Henry]

I was trying to do something like: select count(distinct(something)) from 
table;

it seems this is invalid, although they work individually. Is there a way to 
get something like this to work in sqlite?

Thanks.