expected output assignment 1

Lab Assignment :1

BASIC SQL QUERIES:

EXPECTED OUTPUTS

Q1.

EID

-------

22

24

25

Q2.

ENAME

--------------------

Jenny

Sophia

Peter

Q3.

AID

-----

101

102

Q4.

ENAME

--------------------

Jenny

Peter

Andrew

Q5.

ENAME

--------------------

Andrew

Q6.

EID

----

27

Q7.

EID ENAME SALARY

---------- --------------- - ----------

20 Robin 350000

Q8.

EID

----------

21

Q9.

SUM (E.SALARY)

-------------

1670000

--

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