求一个SQL语句
SELECT UserId,COUNT(1) AS num FROM product GROUP BY userId ORDER BY num desc
这条是在product 表获取每个用户有多少个产品

第二条：select count(1) from subProduct where userId=上面的userId

想要的最终结果是：用户ID 产品总数 SUB的总数


有没有一条SQL语句能解决？

[解决办法]
SELECT UserId,COUNT(1) AS num,
(select count(1) from subProduct where userId=A.userId)

FROM product A GROUP BY userId ORDER BY num desc