1.
SELECT count(t.companyId)/count(1) FROM data.dataanalyst as d
#where companyId = (
#select companyId from data.company
#where companyShortName = '唯医网'
#)
left join (SELECT * FROM data.company
where companySize = '150-500人') as t
on t.companyId = d.companyId
0.2280 |