A table named student is given below.
Roll No |
Name |
Batch |
Percent |
1 |
Hari |
Commerce |
80 |
2 |
Binu |
Science |
85 |
3 |
Saritha |
Bumanities |
|
4 |
Vimala |
Science |
90 |
5 |
Sindu |
Science |
75 |
6 |
Biju |
Commerce |
77 |
7 |
Vinod |
Humanities |
|
Write answers for the questions based on the above table.
1. SQL statement to display the different courses available without duplication.
2. SQL statement to display the Name and Batch of the students whose percentage has a null value.
3. Output of the query select count (percentage) from Student.