求助一条SQL语句

Question

为了把问题描述清楚,我把问题放在网上.
请浏览 http://64.17.131.234/zhujf/ask-sql.html
谢谢

Answer 1

select a.employeId,a.employeName,a.seat,count(b.employeId) from employeInfo a,serviceLog b
where a.employeId = b.employeId(+)
group by a.employeId,a.employeName,a.seat

Answer 2

select 
a.employeId,
a.employeName,
a.seat,
count(b.employeId) 
from employeInfo a,serviceLog b
where a.employeId = b.employeId(+)
group by a.employeId,a.employeName,a.seat

Answer 3

SELECT i.employeId , i.employeName , i.seat ,count(l.employeId)  serviceCount 
FROM employeInfo  i 
LEFT OUTER JOIN serviceLog  l 
ON i.employeId = l.employeId 
GROUP BY i.employeId,i.employeName,i.seat

Answer 4

select a.employeID ,a.employName ,a.seat, nvl(b.con,0) from employeInfo a , (select employeID,count(*)as con from serviceLog group by employeID) b 
where a.employeID = b.employeID(+)