Write an SQL statement that projects the employee name and project name restrict
ID: 3906950 • Letter: W
Question
Write an SQL statement that projects the employee name and project name restricted to projects Mary Jacobs is working on. Show the resulting relation.
EMPNUM FNAME LNAME DEPT PHONE EMAIL 1 Mary 2 Rosalie Jackson Administration 3 Richard Bandalone Legal 4 Tom 5 Heather Jones 6 Mary Abernathy Finance 7 George Smith Human Resources 360-285-8510 George.Smith@WPC.com 8 Tom 9 George Jacobs Administration360-285-8110 Mary.Jacobs@WPC.com 360-285-8120 Rosalie.Jackson@WPC.comm 360-285-8210 Richard.Bandalone@WPC.com 360-285-8310 Tom.Caruthers@WPC.com 360-285-8320 Heather.Jones@WPC.com 360-285-8410 Mary.Abernathy@WPC.com Caruthers Accounting Accounting Jackson Production e Jones Production Numoto Marketing 360-287-8610 Tom.Jackson@WPC.com 360-287-8620 George.Jones@WPC.com 360-287-8710 Ken.Numoto@WPC.com NULL 360-287-8820 Rick.Brown@WPC.com 10 Ken James Nestor InfoSystems Brown InfoSystems James.NestorWPC.com 12 RickExplanation / Answer
If you have any doubts, please give me comment...
SELECT E.FNAME, E.LNAME, P.PNAME
FROM EMPLOYEE E, WORKS_ON W, PROJECT P
WHERE E.EMPNUM = W.EMPNUM AND W.PID = P.PID AND E.FNAME='Mary' AND E.LNAME ='Jacobs';
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.