diff options
Diffstat (limited to 'labs/2/run.sql')
| -rw-r--r-- | labs/2/run.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/labs/2/run.sql b/labs/2/run.sql index 38aa0ef..0b070e2 100644 --- a/labs/2/run.sql +++ b/labs/2/run.sql @@ -97,3 +97,10 @@ CREATE TRIGGER update_sin AFTER UPDATE EXECUTE PROCEDURE update_referenced_sin_numbers(); UPDATE departments SET dnumber = 14 where dnumber = 12; + +SELECT departments.dname, count(distinct(employees.sin)) +FROM departments +INNER JOIN employees on employees.dno = departments.dnumber +INNER JOIN projects on projects.dnum = departments.dnumber +WHERE projects.pname LIKE 'Mobile %' +GROUP BY departments.dnumber; |