SELECT 招聘岗位,COUNT(招聘岗位) AS 岗位信息出现频数 FROM POSITION GROUP BY 招聘岗位;

SELECT 招聘单位, COUNT(招聘单位) AS 单位招聘信息数量 FROM POSITION GROUP BY 招聘单位;

SELECT COUNT(招聘岗位) AS 岗位信息出现频数 from POSITION;

SELECT COUNT(招聘单位) AS 单位招聘信息数量 from POSITION;

#查找相关岗位的平均薪资信息

SELECT

`招聘岗位`,

ROUND(

AVG(

REPLACE ( SUBSTR(薪资区间, 1, 2 ), 'k', '' ))* 1000 

) AS 最低平均薪资,

ROUND(

AVG(

REPLACE (

REPLACE ( SUBSTR(薪资区间, 4 ), 'k', '' ),

'-',

'' 

))* 1000 

) AS 最高平均薪资,

FROM

POSITION 

WHERE

`招聘岗位` NOT LIKE '%实习生%' 

GROUP BY

`招聘岗位`;

#查找相关单位的平均薪资信息

SELECT

`招聘单位`,

ROUND(

AVG(

REPLACE ( SUBSTR(薪资区间, 1, 2 ), 'k', '' ))* 1000 

) AS 最低平均薪,

ROUND(

AVG(

REPLACE (

REPLACE ( SUBSTR(薪资区间, 4 ), 'k', '' ),

'-',

'' 

))* 1000 

) AS 最高平均薪资资 

FROM

POSITION

WHERE

`招聘岗位` NOT LIKE '%实习生%'

GROUP BY

`招聘单位`;

​