diff options
Diffstat (limited to 'labs')
| -rw-r--r-- | labs/2/README.md | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/labs/2/README.md b/labs/2/README.md index b0718a5..25a970c 100644 --- a/labs/2/README.md +++ b/labs/2/README.md @@ -62,10 +62,10 @@ Indicates the name (Consumer Products, Industrial Products, and Research) and nu ```sql CREATE VIEW DEPT_SUMMARY (D, C, TOTAL_S, AVERAGE_S) AS - SELECT DNO, COUNT (*), SUM (SALARY), AVG (SALARY) - FROM EMPLOYEE, PROJECT - WHERE DNO = DNUM and PNAME like 'Mobile%' - GROUP BY DNO; + SELECT DNO, COUNT (*), SUM (SALARY), AVG (SALARY) + FROM EMPLOYEE, PROJECT + WHERE DNO = DNUM and PNAME like 'Mobile%' + GROUP BY DNO; ``` * Which of the following queries and updates would be allowed by this view (from g)? If a query or update is allowed, what would the corresponding query or update on the base relations look like? Give its result when applied to the database. |