Comprehension Passage
Case study based question
An Educational Institute in Delhi make use of DBMS to store details of students. The institute maintains a database named 'school - record' under which there are two tables.
1. Student table : maintains general details of every student enrolled in the school
2. Stulibrary Table: To store the details of issued books.
* BookID is the unique identification number of each book.
* Minimum issue duration of a book is one day.
|
Student |
|
|
Field |
Type |
|
StuID |
Numeric |
|
StuName |
Varchar(20) |
|
StuAddress |
Varchar(50) |
|
StuFatherName |
Varchar(20) |
|
StuContact |
Numeric |
|
StuAadhar |
Numeric |
|
StuClass |
Varchar(5) |
|
StuSection |
Varchar(1) |
|
Stulibrary |
|
|
Field |
Type |
|
BookID |
Numeric |
|
StuID |
Numeric |
|
Issued_date |
Date |
|
Return_date |
Date |
Which of the following SQL queries will display dates on which number of issued books is greater than 5?
1
Select Issued_date from Stulibrary group by Issued date where count(*) > 5;
2
Select Issued_date from Stulibrary group by Return date having count(*) > 5;
3
Select Issued_date from Stulibrary group by Issued date having count(*) > 5;
4
Select Issued_date from Stulibrary group by Return date where count(*) > 5;