diff options
| author | mo khan <mo.khan@gmail.com> | 2019-12-30 16:52:59 -0700 |
|---|---|---|
| committer | mo khan <mo.khan@gmail.com> | 2019-12-30 16:52:59 -0700 |
| commit | 4cb16d0a740e816b429e88d74d628fee271c1ce0 (patch) | |
| tree | 91a47f32a519cace6a21e229f4279251824b61e0 /labs | |
| parent | e4b1b81d1d09e7ce8b09f3a4b772d3fc825791cd (diff) | |
tabs -> spaces
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. |