diff options
Diffstat (limited to 'assignments/final/run.sql')
| -rw-r--r-- | assignments/final/run.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/assignments/final/run.sql b/assignments/final/run.sql index 131a6b9..e6d6a92 100644 --- a/assignments/final/run.sql +++ b/assignments/final/run.sql @@ -311,8 +311,8 @@ GROUP BY c.cid; SELECT * FROM NURSE_SUMMARY; -SELECT D, C FROM NURSE_SUMMARY WHERE TOTAL_S > 100000; +-- SELECT D, C FROM NURSE_SUMMARY WHERE TOTAL_S > 100000; -SELECT D, AVERAGE_S -FROM NURSE_SUMMARY -WHERE C > (SELECT C FROM NURSE_SUMMARY WHERE D=4); +-- SELECT D, AVERAGE_S +-- FROM NURSE_SUMMARY +-- WHERE C > (SELECT C FROM NURSE_SUMMARY WHERE D=4); |