Ms. Manisha, a veterinarian, created a table 'VETERINARY' with the following columns: ANIMAL_ID, VACCINATION_DATE, ANIMAL, OWNER_NAME She wants to see the details of all the animals other than Dog and Cat which she has vaccinated. She has written the following query: SELECT * FROM VETERINARY WHERE ANIMAL NOT IN ('DOG', 'CAT'); Write a suitable alternate query for producing the same result.

SELECT * FROM VETERINARY WHERE ANIMAL != 'DOG' AND ANIMAL != 'CAT';

Kunal has entered the following SQL command in the table 'STUDENT' that has TotalMarks as one of the columns:

SELECT * FROM Student;                         #Statement-1

The total number of rows displayed is 20.

Then Kunal enters the following command:

SELECT * FROM STUDENT WHERE TotalMarks < 100;  #Statement-2

The number of rows displayed is 15.

Kunal then enters the following command:

SELECT * FROM STUDENT WHERE TotalMarks >= 100; #Statement-3

He predicts the output of the above query as 5. Do you agree with Kunal? Give reasons for your answer.

SELECT COURSE_ID, COURSE_NAME FROM COURSE WHERE COURSE_NAME = '_SCIENCE';

Help Mr. Shivaya to write the correct query.