利用SQL对数据分析相关招聘职位的分析
此文意在通过SQL语句,对数据分析相关招聘职位进行循序渐进的分析。文中主要包含company和dataanalyst两个数据表,两表具体特征如下图:
company表:
dataanalyst表:
* 统计每个城市的职位数量和公司数量
SELECT city, COUNT(positionId) AS positionNum, COUNT(DISTINCT companyId) AS compNum FROM `data`.dataanalyst
GROUP BY city;
* 统计每个城市不同学历水平的职位数量
SELECT city, education, COUNT(positionId) AS positionNum FROM `data`.dataanalyst
GROUP BY city, education;
* 只显示职位数量超过100个的城市的数量
SELECT city, COUNT(positionId) AS positionNum FROM `data`.dataanalyst
GROUP BY city
HAVING positionNum > 100;