diff options
| author | mo khan <mo.khan@gmail.com> | 2019-12-30 16:53:42 -0700 |
|---|---|---|
| committer | mo khan <mo.khan@gmail.com> | 2019-12-30 16:53:42 -0700 |
| commit | 84eaef95961a09bfb55a749930128d122f53b894 (patch) | |
| tree | b24216f1b334b11036f199a4abeb2ea925a008b2 /labs | |
| parent | 4cb16d0a740e816b429e88d74d628fee271c1ce0 (diff) | |
Align questions
Diffstat (limited to 'labs')
| -rw-r--r-- | labs/2/README.md | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/labs/2/README.md b/labs/2/README.md index 25a970c..f731baf 100644 --- a/labs/2/README.md +++ b/labs/2/README.md @@ -70,8 +70,8 @@ CREATE VIEW DEPT_SUMMARY (D, C, TOTAL_S, AVERAGE_S) AS * 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. -Q1. `SELECT * FROM DEPT_SUMMARY;` -Q2. `SELECT D, C FROM DEPT_SUMMARY WHERE TOTAL_S > 100000;` -Q3. `SELECT D, AVERAGE_S FROM DEPT_SUMMARY WHERE C > (SELECT C FROM DEPT_SUMMARY WHERE D=4);` -Q4. `UPDATE DEPT_SUMMARY SET D=3 WHERE D=4;` -Q5. `DELETE FROM DEPT_SUMMARY WHERE C > 4;` +1. `SELECT * FROM DEPT_SUMMARY;` +2. `SELECT D, C FROM DEPT_SUMMARY WHERE TOTAL_S > 100000;` +3. `SELECT D, AVERAGE_S FROM DEPT_SUMMARY WHERE C > (SELECT C FROM DEPT_SUMMARY WHERE D=4);` +4. `UPDATE DEPT_SUMMARY SET D=3 WHERE D=4;` +6. `DELETE FROM DEPT_SUMMARY WHERE C > 4;` |