支持这种子查询吗？

[dingzhjie]

select count(DISTINCT deviceId) from uv where deviceId in (select deviceId from uv where userId = 'unknown') and uv.userId != 'unknown';

[cch123]

@dingzhjie ，不支持~