Chce sobie wybrac w zapytaniu ile dany pracownik ma zakonczonych prac a pozniej chcialem sprawdzic ile ma prac np niezakonczonych
lect count(1) AS job1, emp from (select jobno, employee.fullname AS emp, datecompleted as day, jobtype, (select count(1) from work where work.jobno = job.jobno) as work
from job
LEFT JOIN employee ON (employee.employeeid = job.engineer)
where datecompleted >= '2017-09-1' and datecompleted <= '2017-09-14' and job.jobno not like 'W%'
and job.jobno not like 'B%' having (jobtype != 3)
or (jobtype = 3 and work > 0) ) as b
group by (emp) order by emp asc
A pytanie jest jak zrobic zeby bylo cos w stylu
SELECT count(1) AS job1, count(1) AS notend, emp from (SELECT ...ze tu bedzie liczyl ten count1 jako job) , (SELECT ... stad by bral notend)
To jak to zrobic? czy zupelnie cos innego tu trzeba zrobic.