summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authormo khan <mo.khan@gmail.com>2019-12-30 16:52:59 -0700
committermo khan <mo.khan@gmail.com>2019-12-30 16:52:59 -0700
commit4cb16d0a740e816b429e88d74d628fee271c1ce0 (patch)
tree91a47f32a519cace6a21e229f4279251824b61e0
parente4b1b81d1d09e7ce8b09f3a4b772d3fc825791cd (diff)
tabs -> spaces
-rw-r--r--labs/2/README.md8
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.