Fwd: Expected results for RDBMS lab assignment 4

---------- Forwarded message ----------
From: RAMAN SIDHU <ramansidhu1985@gmail.com>
Date: Thu, Feb 10, 2011 at 8:24 PM
Subject: Expected results for RDBMS lab assignment 4
To: Rajwinder Sir <cecm.cse@gmail.com>


Expected results for Assignment 4:

1. count
   -------
   3
   (1 row)
   
   
2. building | sum
   ----------+-----
   Painter | 10
   Taylor | 70
   Packard | 500
   Watson | 80
   (4 rows)
   
   
3. max
   -----
   1
   (1 row)
   
   
4. dept_name | num
   ------------+-----
   Elec. Eng. | 1
   Music | 1
   Biology | 1
   (3 rows)
   
   
5. id | name | sum
   -------+----------+-----
   98765 | Bourikas | 7
   76543 | Brown | 7
   98988 | Tanaka | 4
   19991 | Brandt | 3
   12345 | Shankar | 14
   55739 | Sanchez | 3
   45678 | Levy | 7
   23121 | Chavez | 3
   76653 | Aoi | 3
   44553 | Peltier | 4
   00128 | Zhang | 7
   54321 | Williams | 8
   (12 rows)
   
   
6. count
   -------
   6
   (1 row)
   
   
7. name
   -----------
   Wu
   Mozart
   Einstein
   Califieri
   Crick
   Brandt
   Kim
   (7 rows)
   
   
8. id | name
   -------+---------
   12345 | Shankar
   (1 row)
   
   
9. dept_name | sum
   ------------+-----------
   Comp. Sci. | 232000.00
   Elec. Eng. | 80000.00
   Physics | 182000.00
   Biology | 72000.00
   History | 122000.00
   Music | 40000.00
   Finance | 170000.00
   (7 rows)
   
   
10. name
    ----------
    Zhang
    Shankar
    Brandt
    Chavez
    Peltier
    Levy
    Williams
    Sanchez
    Snow
    Brown
    Aoi
    Bourikas
    Tanaka
    (13 rows)
    
    
    

--

Rajwinder Singh
Head, Dept of Computer Science and Engineering
First Floor , Engineering Block I,
Chandigarh Engineering College, Landran (Mohali)-140307, Punjab, India
Phone : +91-0172-3984200 Ext  216
             +91-0172-3984216 (Direct)
             + 91-  9781925246 (Mobile)
Fax : +91-0172-3984207
E-Mail:cecm.cse@gmail.com
URL : www.cecmohali.org/cse.asp

Blog URL : www.ac2dc.blogspot.com