统计应聘人数

Question

有3个表：

1.users (id_user, name)
2.job_post (id_post,id_company,jobtitle)
3.apply_job_post(id_apply, id_post,id_user)

如何统计特定的求职人数-任何人都可以帮助我

Answer 1

您需要对它们进行计数和分组

select id_user,count(id_post) from users
left join apply_job_post on apply_job_post.id_user = users.id_user
left join job_post on apply_job_post.id_post = job_post.id_post
group by users.id_user

Answer 2

如果您想要获取分配给特定作业的用户数，请使用以下查询：

SELECT
    count(u.id_user)
FROM apply_job_post AJP
LEFT JOIN job_post JP ON JP.id_post=AJP.id_post
LEFT JOIN users U ON AJP.id_user=U.id_user
where JP.id_post=2

如果您想获取分配给某个特定用户的作业数量，则可以使用以下查询：

以下示例显示了分配给id_user=1的作业数

SELECT
    count(u.id_user)
FROM apply_job_post AJP
LEFT JOIN job_post JP ON JP.id_post=AJP.id_post
LEFT JOIN users U ON AJP.id_user=U.id_user
where u.id_user=1

如果你想从三个表中获取全部数据，那么：

SELECT
    U.*,
    JP.*,
    AJP.*
FROM apply_job_post AJP
LEFT JOIN job_post JP ON JP.id_post=AJP.id_post
LEFT JOIN users U ON AJP.id_user=U.id_user