ORACLE根据某个字段的特定值进行统计？

select A.user_id,count(1) from table A , （select user_id ，max(version_type) m_version from table group by user_id ) Bwhere A.user_id = B.user_idand A.version_type = B.m_versiongroup by A.user_id