Employee table Jobhistory table Count the number of different employee who have

Question

Employee table


Jobhistory table
Count the number of different employee who have been on any course: I do this quary: Select count(distinct empno) From jobhistory Where enddate is not null;
And it's give me just14% overall mark and it should be 100% ... The link below has the website to check your quary
http://db.grussell.org/sql/interface.cgi?tn=Tutorial%203&qn=2

select *from course COURSENOCNAME CDATE CNAME Basic Accounting 2 3 4 11-JAN-89 Further Accounting 25-JAN-89 Issues In Administration27-SEP-88 Iisues In Adminstration 127 SEP-38 More Administration 16.OCT-88 01-NOV-88 Introduction To Ingres 05-FEB-89 Ada introduction To Ingres-105-FEB-89 10-MAR-89 12-DEC-88 Structural Stress Analysis 20-FEB-89 24-OCT-88 6 New Topologies LANS 10 Taffic Flow Analysis

Explanation / Answer

the solution is below:

SELECT COUNT(DISTINCT EMP.EMPNO)
FROM EMPLOYEE EMP, EMPCOURSE EMPC
WHERE EMPC.EMPNO = EMP.EMPNO;

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.