consider the following table structure of students rollno int name varchar 20..., MySQL, Databases

Test
- Model Test
Index

Question:Consider the following table structure of students:rollno int
name varchar(20)
course varchar(20)
What will be the query to display the courses in which the number of students enrolled is more than 5?

A Select course from students where count(course) > 5; 
B Select course from students where count(*) > 5 group by course; 
C Select course from students group by course; 
D Select course from students group by course having count(*) > 5; 
E Select course from students group by course where count(*) > 5; 
F Select course from students where count(group(course)) > 5; 
G Select count(course) > 5 from students; 
H None

/71

+ AnswerD

+ Report

Descriptive on MySQL Ebook

Total Preview: 732

Question:Consider the following table structure of students:rollno int name varchar(20) course varchar(20) What will be the query to display the courses in which the number of students enrolled is more than 5?

A Select course from students where count(course) > 5;

B Select course from students where count(*) > 5 group by course;

C Select course from students group by course;

D Select course from students group by course having count(*) > 5;

E Select course from students group by course where count(*) > 5;

F Select course from students where count(group(course)) > 5;

G Select count(course) > 5 from students;

H None

D

Question:Consider the following table structure of students:
rollno int name varchar(20) course varchar(20)
What will be the query to display the courses in which the number of students enrolled is more than 5?