select COUNT(*),eie_id from today group by eie_id  

select COUNT(*),company from today t join  eie_info e
on t.eie_id=e.eie_id
group by company

------解决方案--------------------

SQL code
select COUNT(1),b.company from today a,eie_info b 
where a.eie_id=b.eie_id
group by b.company

------解决方案--------------------

SQL code


SELECT  company ,
        COUNT(*)
FROM    today a
        LEFT JOIN eie_info b ON A.eie_id = B.eie_id
GROUP BY company