mysql - 查找count个职位并申请成员(member)mysql

Question

我有两张 table

job
id job_name
1  php
2  python
3  ROR


applied_user
id job_id user_id
1  2      4
2  2      5
3  2      5
4  1      54

现在我想通过单个查询计算有多少个职位和申请的成员

jobs applied_user
3    4

Answer 1

这将向您显示已申请的独特职位数量和独特用户数量

SELECT
  COUNT(DISTINCT job_id) as jobs, 
  COUNT(DISTINCT user_id) as applied_user
FROM
  applied_user