A table named student is given below.Roll NoNameBatchPercent1HariComme

1.	A table named student is given below.Roll NoNameBatchPercent1HariCommerce802BinuScience853SarithaBumanities4VimalaScience905SinduScience756BijuCommerce777VinodHumanitiesWrite 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.
Answer» 1. Select distinct batch from Student; 2. Select name, batch from Student where percent is null 3. 5

A table named student is given below.Roll NoNameBatchPercent1HariCommerce802BinuScience853SarithaBumanities4VimalaScience905SinduScience756BijuCommerce777VinodHumanitiesWrite 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.

Answer»

1. Select distinct batch from Student;

2. Select name, batch from Student where percent is null

3. 5