IN SQL PLEASE employee emp ssn emp_ last_mame emp first_name emp middle_name emp
ID: 3891578 • Letter: I
Question
IN SQL PLEASE
employee emp ssn emp_ last_mame emp first_name emp middle_name emp address emp city emp state emp emp_date_of birth emp salary emp_parking_space emp gender emp-apf number tworks Here caldpt-narne emp-Supersm Supervise Has Employee project assignment Works On swork emppro_number work_ pro_mumber work hous pro name pro_location pro_dept_number Controls Proj i Manage Dept department dept locations dpt_no H-- -- dpt_ao Locsted In dpt_location apt mgrssn dpt mgr_start_date dependent Primary Keys (PKs) boldfaced Foreign Keys (FKs) Ralicized FK that is also part of a PK = boldfaced and italicized dep_name Has Dependent dep_gender dep date of birth dep_relationshipExplanation / Answer
Answer:
Here, I have written script for the above SQL as given below ,
SELECT employee.emp_SSN, assignment.work_hours
(SELECT pro_number FROM project ORDER By pro_number ASC;) FROM employee, assignment;