Page 1 of 1
2. Fill in the two blank lines 1) and 2) below with correct SQL clauses in the following SQLQ2 : For each department tha
Posted: Thu Jul 14, 2022 2:17 pm
by answerhappygod
- 2 Fill In The Two Blank Lines 1 And 2 Below With Correct Sql Clauses In The Following Sqlq2 For Each Department Tha 1 (147.33 KiB) Viewed 36 times
2. Fill in the two blank lines 1) and 2) below with correct SQL clauses in the following SQLQ2 : For each department that has more than 2 employees, retrieve the department name and its employees (ssn and last name) who are making more than $40,000. Q2: Select Distinct D.dname, E.ssn, E.Iname From Employee E, Department D Where E. salary > 40000 and E.Dno = D.Dnumber and E.Dno in (Select E1.Dno From Employee E1 1) 2)