Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
203 views
in Structured Query Language by (31.3k points)
closed by

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.

1 Answer

+1 vote
by (30.9k points)
selected by
 
Best answer

1. Select distinct batch from Student; 

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

3. 5

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...