Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help me with the correct answers lowing queries will find the Name of the Employee and the name of the 2. Which of the
Please help me with the correct answers
lowing queries will find the Name of the Employee and the name of the 2. Which of the following queries will find the Name Departments they work? 3. SELECT Dname, Ename FROM Dept d, EMP e, IN DEPT i: b. SELECT Dname, Ename FROM Dept d, EMP e, IN_DEPT i WHERE i.EID = e.EID AND d.DID = i.DID: c. SELECT Dname, Ename 5 CD FROM Dept d INNER JOIN IN DEPTI ON d.DID=i.DID INNER JOIN EMP e ON 1.EID = e.EID; d. SELECT Dname, Enane FROM Dept d NATURAL JOIN IN_DEPTI ON d.DID = i. DID NATURAL JOIN EMP e ON LEID = e.EID; e SELECT Dname, Ename FROM Dept NATURAL JOIN IN_DEPT NATURAL JOIN EMP; F. None of the above 3. Which of the following queries finds the number of employees: . SELECT count(*) FROM EMP; b. SELECT count(EID) FROM IN DEPT; L. SELECT count(DISTINCT EID) FROM IN DEPT; a SELECT DISTINCT count(ED) FROM IN DEPT; 2. SELECT count(*) FROM ( SELECT EID FROM IN_DEPT GROUP BY EID); ( None of the above ACE lowing queries will find the Name of the Employee and the name of the 2. Which of the following queries will find the Name Departments they work? 3. SELECT Dname, Ename FROM Dept d, EMP e, IN DEPT i: b. SELECT Dname, Ename FROM Dept d, EMP e, IN_DEPT i WHERE i.EID = e.EID AND d.DID = i.DID: c. SELECT Dname, Ename 5 CD FROM Dept d INNER JOIN IN DEPTI ON d.DID=i.DID INNER JOIN EMP e ON 1.EID = e.EID; d. SELECT Dname, Enane FROM Dept d NATURAL JOIN IN_DEPTI ON d.DID = i. DID NATURAL JOIN EMP e ON LEID = e.EID; e SELECT Dname, Ename FROM Dept NATURAL JOIN IN_DEPT NATURAL JOIN EMP; F. None of the above 3. Which of the following queries finds the number of employees: . SELECT count(*) FROM EMP; b. SELECT count(EID) FROM IN DEPT; L. SELECT count(DISTINCT EID) FROM IN DEPT; a SELECT DISTINCT count(ED) FROM IN DEPT; 2. SELECT count(*) FROM ( SELECT EID FROM IN_DEPT GROUP BY EID); ( None of the above ACE
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started