Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.
Table: Student
| Admno | Sname | Class | Sec | Fee | Mobile | Area | S_ID |
| 1001 | RAMESH | XII | A | 2500 | 987654321 | Madipur | 10 |
| 1078 | KRISHNA | XII | B | 2400 | 999911111 | Jawala Heri | 30 |
| 1006 | FARDEEN | XII | C | 2600 | 987654321 | Paschim Puri | 40 |
| 1004 | SUBHAM | XII | A | 2500 | 963025874 | Madipur | 20 |
| 1029 | KRITIKA | XI | C | 2700 | 987456210 | Madipur | 30 |
| 1008 | SAMEEKSHA | XII | A | 2450 | 987123456 | Mangol Puri | 20 |
| 1025 | SALMA | XII | B | 2580 | 998877445 | Madipur | 30 |
| 1036 | AMANDEEP | XII | B | 2600 | 999333555 | Khyala | 40 |
| 1037 | TEJAS | XI | C | 2650 | 987951357 | Paschim Puri | 40 |
| 1029 | HIMANSHU | XII | A | 2750 | 951369874 | Jawala Heri | 10 |
Table : Stream
| S_ID | Stream_name |
| 10 | MEDILCAL |
| 20 | NON MEDICAL |
| 30 | COMMERCE WITH MATH |
| 40 | COMMERCE WITH IP |
| 50 | HUMANITIES |
Write SQL commands for the statements (a) to (h) on the above table: Student and Stream
(a) Identify Primary Keys and Foreign Key in the table student and primary key in Stream table given above.
(b) Display stream id and stream-wise total fee collected.
(c) Count no of students from each area.
(d) Display all the student details those who belongs to Madipur Area.
(e) Increase the fees of all students by10%.
(f) Display unique area from the student table.
(g) Display details of those students whose area contains ‘Puri’.
(h) Display the information of those students who are in class XII and section is either B or C.
Infrared, Coaxial Cable, Ethernet Cable, Microwave, Optical Fiber
Write the output produced by the following SQL commands: