Question

- Write SQL commands for the following on the basis of given table STUDENT:

No. Name Stipend Stream AvgMark Grade class
1 Karan 400 Medical 78.5 B 12B
2 Divakar 450 Commerce 89.2 A 11C
3 Divya 300 Commerce 68.6 C 12C
4 Arjun 350 Humanities 73.1 B 12C
5 Sabina 500 Nonmedical 90.6 A 11A
6 John 400 Medical 75.4 B 12B
7 Robrt 450 Humanities 64.4 C 11A
8 Rubina 250 Nonmedical 88.5 A 12A
9 Vikas 300 Nonmedical 92.0 A 12A
10 Mohan 500 commerce 67.5 C 12C


(a) Display all the nonmedical stream students from STUDENT. (1)
(b) List the names of those students who are in class 12B. (1)
(c) Update all the students of CLASS 11A in a stipend field (add 20). (1)
(d) Display a report, listingname, stipend, stream and amount of stipend. (1)

Answer 1

Explanation:

400 Medical 75.4 B 12B

7 Robrt 450 Humanities 64.4 C 11A

8 Rubina 250 Nonmedical 88.5 A 12A

9 Vikas 300 Nonmedical 92.0 A 12A

10 Mohan 500 commerce 67.5 C.

Answer 2

Answer:

पप्पू को एक भिखारी मंदिर के बाहर मिला...!

भिखारी - भगवान के नाम पर कुछ दे दो साहब,

चार दिन से कुछ नहीं खाया...!

पप्पू - 500 का नोट निकालते हुए बोला 400 खुले हैं।

भिखारी - हां जी साहब हैं।

पप्पू - तो उससे कुछ लेकर खा ले।